The best seats AT a football game (major college or pro) are in the first row lower-level. Mascots, cheerleaders, players warming up, etc. Always something to watch, my kid and I were dancing on the jumbotron at JTS earlier this year. The entertainment value of the front row can't be beat. You can't really see the game at all though, but that's not why I drive 4 hours to watch 1 game a year in person.
The best seats to WATCH a football game are at home on your couch. Replays, super slow-mo, the best angles, etc. If I actually care about watching a game. I stay home.