The Blackheart sidequest in Fallout 3: point lookout. Not only was it Lovecraft themed, it was also entertaining and creepy. the fact that they actually made you travel from the DLC place all the way back to the real map, then return to a building that was already creepy and made it even creepier made it also much more fun.