I'm trying to look for some software like below, preferably open souce but that doesn't matter to much http://www.martechsocial.com/ It's basically an all in one community site where a forum, blog, video sharing, reviews, etc are all grouped together in one site. Probably asking a lot but does this exist? Even if I have to pay for it...
I have used http://www.cmsmadesimple.org/ on lots of small/medium sites including online shops and many community type webs simular to what you are looking for. I find some of the CMS a little too bloated for most peoples need, this one you just install what modules you need and its well written and nicely finished IMO
