I love Fallout 3 but yeah, FL3 is basically a futuristic, depressing version of Oblivion. As for the horror, some of the enemies are creepy (deathclaws, bears) and there's a vault where you have mysterious flash backs if you go inside of it.
But yeah, I'd say go for it. It's an awesome game