There's some quests that are way better later on, specifically the quests involving the mutants. Dead City is just awesome and Mutant Bash TV was pretty cool too, if the entire game was like that it would be so much better. Screw the gun fights with the other humans, though they aren't horrible, the mutants are a much better enemy.
I'm not sure why there's so much hate for this game. Sure I agree it could have been better, and longer would definitely be better, but it's no where near as bad as people are saying it is.
I actually like being able to drive from town to town too, it sure beats the hell out of the long ass runs you have to do in Fallout.