There's no question about it - Fifa. Fifa 2002 to be precise - it was the first one I owned, and still my favourite.
90 minute matches? Why not! Want to get players deliberately sent off by sliding in on the keeper? Go for it! It was absolutely groundbreaking at the time, and I can still enjoy it nowadays, which is impressive (given that Fifa games from 3-4 years ago feel pretty dated already).
Honourable mentions to SSX and Tony Hawk's Pro Skater though - they may be classified as 'extreme' sports more than anything, but both of them were great games.