Definitely RE2. RE3 comes close, but 2 takes the cake still. Loved that there were 2 campaigns, I liked all of the characters, thought the police station setting was great and it was just generally a fun game.
Bonus question: Hope it gets cancelled and they make a zombie game instead. IMO there hasn't been a good mainline RE game since RE3. I expect I'll be disappointed though.