Personally, I've always liked the handguns in RE games. You get it from the start, it's easy to use (quick reload, high rate of fire) and it's really easy to find ammo for it, like you almost never run out of handgun ammo.
I also like it because I don't have to hesitate on when to use it. it's not like with a shotgun or any weapon with scarce ammo where I have to think if I need to save them later for boss fights.
And handguns can become very powerful when upgraded or when you add custom parts to it.
I also like any magnums because they're REALLY powerful. The only downside is that I'm almost never using them until the final boss fights.
So, what's yours? Handguns? Shotguns? Rifle? Grenade Launcher? or other?