Well, Fallout 3 is full of plenty cool and creepy places. Just to name a few...
Cool:
Deathclaw Sanctuary - A great place for all of you, Deathclaw bounty hunters, out there!
Coastal Grado(Point Lookout) - Be on the hunt! Because in the Coastal Grado...you'll get a benefit, after finishing off the ghouls.
Dunwich Building - After hearing creepy and eerie things go down, here, by several other wastelanders...wouldn't you wanna go and take a look, at the building yourself?
Little Lamplight - A settlement full of children. What is their not to love?
Vault 108 - A vault, full of failed clones all named "Gary". Watch your back here.
Vault 106 - While traveling through this vault...if you witness purple lighting and past delusions...don't be alarmed.
Jury Street Metro Station/Marigold Station/Bailey's Crossroads Metro/Flooded Metro/Metro central - All great metros to roam and explore. Don't be afraid to scavenge, all you can. It might just save your life.