I'm playing Tainted Grail: The Fall of Avalon and there are some really funny moments.
There's this quest where a corpse is hanging from a tree and asks you to deal with some creatures that come at night and do the sexy things where he can see them. Or two drunk guys in a tavern debating if a broken sword that has been reforged and it's hilt replaced time and time again would still be the same sword. Or there is this undead crypt keeper, really happy to meet you.