Arguably the best sports trip I've been on was going to the 2005 PGA Championship at Whistling Straits, Kohler, WI.
5 days in Green Bay allowed us to see Lambeau Field as well as watch Packer training camp. The tournament was great, got to see legends like Norman, and Faldo, watched John Daly shoot an 8 on a par 4, and the tourney went to a playoff!
Vijay Singh won, so it was double good for me.
I went to the NASCAR race in Vegas a few years ago. You don't have to like the sport to have a good time at a race. Everything is so colorful, loud, fast and the ladies aren't too shabby either. I'd recommend for anyone to go.
All of my other trips have been for LSU football, or New Orleans Saints games. LSU is by far more fun, and if you ever have a reason to go to South Louisiana in the fall, take in an LSU tailgate, and maybe even the game if you can fit it in...
I'm going to Seattle in early September to watch LSU play Washington, Game 1 of another championship run for the Bayou Bengals! I'm going to try to fit in a Mariners/Angels game, and a bit of the Bonaroo festival as well.