Alright, in general I don't really play too many sports video games. I've mostly grown to hate Madden now because of the exclusive NFL licensing. However, back in the NES days, it was a different story. Here would be my list.
#1 - Mike Tyson's Punchout (I don't want to hear about the newer versions of the game. The original is a classic and has totally withstood the test of time).
#2 - Nintendo World Cup Soccer for the NES (You could play on Grass / Sand / Dirt / and even Asphalt! You could just brutally tackle guys, injure people, and each team had guys with special power up kicks. Also...Bicycle Kick FTW!!
#3 - Super Spike Beach Volleyball on the NES. Kind of similar to World Cup Soccer in my book. Volleyball with awesome powerups in a similar graphical style.
#4 - Any of the EA NHL games. They are all consistently good, and I think Hockey translates very well to a video game. I especially love the versions on SNES / and the early Playstation versions.