Resident Evil 4 is a good example of how I prefer it to be done. You can pretty much max out every weapon class in one playthrough if you know what you're doing, and you do become a one man army by the last hour or so, but the game throws enough guys at you that it manages to be empowering without becoming a pushover.