Sometimes it goes for the worst though...I was playing Sacred 2 today and stumbled upon a guy who wanted his instruments back so he could play a metal concert, (WTF? This is a fantasy game) it was the cheesiest thing I've ever seen ever. After completing the quest,  It had like a full CG cutscsene of them playing and using their "axes" har har. With skeletons and ogres in the background jumping up and down. I was /facepalming all the way through it. IT WAS SO RANDOM TOO!
 
The only good thing that came out of it was the loot...

I'm still playing the hell out of fallout 3 and during my travels I stumbled upon a neat quest.
 
The Nuka Cola Challenge
 
I loved the tour of this eccentric girls Nuka Cola collectibles, it gave  the character  an "edge" that so many other quests/characters lacked. 
If they (the developers) had put a scripted event or some believable characters elsewhere such as Paradise Falls; it would have worked wonders on some of the stale 
pieces of Fallout 3.