SvR 06 was only good for the online. Most active online community ever in a wrestling game. The games that followed have since had terribly stale online.
As far as GOAT wrestling game, i have to gith HCTP. No Mercy was great, but HCTP had the GOAT roster as well as a nice depth in movesets.
I have the PS3 slim so its no backwards compatible, but with PCSX2 i've been able to play HCTP (or any PS2 game) on my computer. Runs pretty smooth too. Just wish there was some game save out there with a bunch of tna/new wwe/indi/japan caws.