I just pulled out Hardball V, and it paled in comparison to Hardball III. I'm currently 54-43 in my season with the Toronto Blue Jays (good ol' logo editing), and I'm actually using my second computer for more than just laughing at it...
Another game I remember is World Championship Soccer II. It's the only game where I can play as Canada in the World Cup
Another awesome game was NHL '96, the first game with a full 82 game season mode (I believe). The Blackhawks were unstopable in that game, with Belfour, Chelios, Suter, Roenick, Amonte, and Joe Murphy in the starting lineup.
And finally, there was a College Football game that came out in early '94 (not Bill Walsh) that had a season mode. Does anyone remeber the name of that game? I'd like to look for it at EB.