When I was a young kid WWF Raw for the SNES was the one I played the most. I just loved listening to the wrestlers' theme songs in the select-a-wrestler screen.
WCW/nWo Revenge was the best for its time and most fun to just screw around with friends on, but Wrestlemania 2000 using the same engine was mindblowing because they had entrance music and a career mode with storylines. It blew my mind on Thanksgiving weekend of 1999 when the Big Boss Man did a run-in on my CAW's match in career mode and then there was a cutscene where he cut a promo. Prior to that, every wrestling game career mode was just one match after another with no real story elaboration, except for Warzone with its hilariously bad videos. No Mercy may have been an improvement in gameplay modes, and I know people swear by it, but they cut some stuff I liked (entrances were truncated) and the roster in WM2000 spoke to me more because 1999 was my peak fandom.
The PS2 era ones were alright, but nothing special. Last one I owned was either SvR 2006 or 2007, don't remember exactly. Not that memorable.