Frag videos are only so good, folks. If you haven’t seen it, run a search for Clan Wars on fileplanet. It’s a movie I co-directed a few years ago with some friends, done in 1.6 and Source. It’s got your explosions, blood, comedy, kung fu, Gooseman, etc. Pretty standard stuff. Also, I need not mention it, but also check out Militia 2 if you’re one of these new bloods that hasn’t seen real CS machinima.
EDIT: Apparently CW is so old that it’s become hard to find on the interwebs. Check out http://www.gwchannel.tv/ and open up the player, it’s on there.