I think RE4 did a pretty good job of balancing the weapons, and by that I mean you could use whichever weapon you preferred throughout the game. Sure, some are definitely better than others, but it doesn't mean you have to use these weapons to beat certain enemies or areas.
I dig eet.