I have not watched a single negative video on the raspberry pi. The last one I watched was with a guy setting one up. I also watched a 30 minute one with Leo Laporte.Why do we need to post video to justify our own experience and satisfaction of the Pi to you? We stated over and over, if you prefer a full PC and the cost + power consumption behind that, do it and exit this thread.
Otherwise, you can watch all the youtube videos you want. For every one youtube video you find that bashes the Pi, there will be another who raves about it. It all boils down to what you expect out of it vs. what you pay for it. It's been stated a thousand times, it is NOT as powerful as a full PC. It doesn't have the features of a full PC. Can it handle video and such well? Yes. Does it do it for less than a full PC? Probably.
If you buy a 10 speed bike expecting to go drag racing and win, you will inevitably be disappointed with your results.