I'd recommend "Before I Kill You Mr. Bond." It's not quite RPG-sih, but the very nature of the game promotes strange eeeeeeevil accents and maniacal laughter.
Cheapass Games have been a bit of a mixed bag, IMHO. Before I Kill You Mr Bond is good, but some others are a little too convoluted or unclear.
Edit, added: There's also Chez Geek and Munchkin, a lot of fun but the games can be over rather quickly and they are a bit more expensive.