It's really good, but there does seem to be quite a few people who don't enjoy the game. Out of my friends only 1 other enjoyed it, the rest suffered headaches or didn't like the story.
Admittedly I told them they were retarded and Fallout 3 kicks major ass but it's all about what you prefer. I recommend borrowing or renting it for a day, play a few levels and see what you think.