Well... I say "a few of them" but there's really only one cool feature at this point. And that is the fact that average joe idiot, with his handy-cam, can take videos and then put them up for sale (or free) on Google Video. Now, there are a number of "video" websites out there that scour the web for funny amateur videos, but they are usually maintained by a guy (or a couple guys) who post what they find interesting. And that's not bad... a few of my favorites sites are video sites like that (i.e. StupidVideos). But here, anyone who even thinks their stuff is funny/cool can post it, and because of this, you can run across a few "gems" that may not be up on any of the more well-known video sites.
That said,... here are a few "interesting" videos that I've found on Google Video...
Two emo punks are recording themselves doing really lame stuff on their skateboards when they inadvertently film a little old lady who totally pwnz0rz a preppy, stuffed-shirt in a Mercedes.
The classic, "Light your gaseous emissions on fire" bit.
I'm pretty sure these people didn't know they were being filmed.
Here's a lame one of someone trying really hard to be Napoleon Dynamite.
Guy gets totally pwned by a Bull... in the worst possible way.
Here's a song that no one on planet earth can understand the words to... so someone decided to do the best they could to decipher it.
Warning... This is only interesting if you are a total nerd like myself: Geeks overclock a Duron to 4GHZ and it blows a hole through a table.
More nerdy delight: Same geeks overclock a video card... to a flaming death.
This would probably look really cool if it was done on an all black stage. But still pretty wild nonetheless.
If you like watching people completely embarrass themselves on television... then this is the video for you.
I've seen this on a few other sites, but this is the best car commercial ever... so I figured I'd include it.
A kid with way too much wasted free time on her hands. 
Anyway... you get the point. Pretty much the only saving grace of Google Video, at the moment, is the amateur videos. Hopefully, sometime soon, the pay service will catch up with the free portion.
WATYF