Leon is a great character. He is not overrated at all.
However, I do kind of hate 4-6 for having minimal terror. I never had to worry about ammo running out. You buy it, or have enemies (including creatures) dropping it. I've never really liked that kind of gameplay, because it was then nothing like the creepy, survival based earlier games, in which you had to manually locate whatever you could salvage.
People just tell me it's something Capcom incorporated, so it's their rules and so on. But it's not grounded in any obvious realism. Games aren't real, obviously. But you get my drift, surely. They just ruined the feeling.
The bosses are also rather lame. It's craziness.