This is a huge problem with me as well. It even extends to watching other people play the game. x) All I can think is "No, stop spending money on the (handgun)! You're gonna get the Red9 soon!"
As for myself, no I didn't just spend a lot of time looking at every single gun in the series, why would you say that? But after literally doing just that, I'll have to say the Rifle (Springfield M1903A4) from RE4. It's not the best sniper rifle in the series, but it's my favorite. I have a weakness for old bolt action rifles, having owned and shot quite a few of them. It's no slouch in RE4 either. When fully upgraded it does almost as much damage as a magnum and it's best feature is it's reload animation. Hnnnghhh stripper clip, bolt sliding forward. It gives me life.
View attachment 26738