For the SNES, I used to kill hours, days, and weeks playing WWF Royal Rumble. I loved playing this game! There were a few more for the SNES and NES I liked, but I don't really remember them.
For the PS2, I liked all of the Smackdown! games, and the Raw vs Smackdown! games.