The old N64 Blitz was the best. That has to be the best sports game made (well when it comes to playing with others that is). Mario Tennis is also a classic.

If you are playing alone in a franchise mode, basketball and football games have the most to offer