My favorite is still Smackdown vs Raw 2007. I have a full roster of created characters and still play it all of the time. There are bizarre glitches here and there but I've accepted them as just part of the game after playing it for over a decade . I'm not a very prolific gamer, so I totally suck at playing the newer ones.
Also Tecmo Pro Wtesling is easily my favorite NES wrestling game. And for the arcade, nothing beats Saturday Night Slam Masters. Pure magic.