I'm a little late on this, but I am surprised nobody has mentioned WWF No Mercy or any of the other AKI/THQ N64 wrestling games. I remember I had friends that didn't even like pro wrestling, but they played this game. If you can get a Gameshark and want to play the greatest wrestling game ever, look for Virtual Pro Wrestling 2. It was a Japan only release, but it is hands down the greatest wrestling game in my opinion.
i just can't bring myself to have anything to do with "pro" wrestling. i can feel the brain cells dying just looking at the "fighters".