I cant believe people are saying that the SD vs Raw series is the best American wrestling game... Day of Reckoning 2 imo, is far superior, and much closer to the old AKI developed wrestling games we loved on the N64. SD vs RAW may have more bells and whistles, and that stupid elimination chamber, but DoR2 blows it away in terms of the pacing and feel of the wrestling.
But people are correct in saying that the japanese games are better. King of Colosseum 2 and Fire Pro Returns for the PS2 are the 2 best wrestling games ever made, bar none.
For US games, I reccomend DoR2 for the cube first, then SD vs RAW series on PS2 as a distant second.
Also, since you can pick them up at bargain prices, I highly reccomend the Def Jam series, both Vendetta, and Fight for New York. These two games were actually developed by AKI, so they have that old-timey N64 feel. If you can get over the ridiculous hip hop premise, they are actully very good games.