I have been to a few in my area:

For me:
Home games:
Papa Johns Cardinal Stadium (Louisville)
Maryland Stadium (college Park, MD)
Johnny U Stadium (Towson, MD)
LT Smith Stadium WKU (Bowling Green, KY)

As Visiting team:
Nippert Stadium (Cincy)
Liberty bowl (Memphis)
Mountianeer Field (Morgantown, WV)
Joan C Edwards Stadium, Marshall (Huntington, WV)
Lincoln Financial Field Temple (Phila)

Commonwealth Stadium (Lexington, KY)
Navy-Marine Corps Memorial Stadium (Annapolis, MD)
Memorial Stadium (Clemson, SC)
MM Roberts Stadium - Southern Miss (Hattiesburg, MS)
Scott Stadium -UVA (Charlottesville, VA)
Note Dame Stadium

Bowl games/Neutral Site games
M&T Bank Stadium (Army vs. Navy)
Paul Brown Stadium, Cincy
Lincoln Financial Field (Army v Navy)
Liberty Bowl
Superdome
Georgia Dome
Sunlife Stadium, Miami (before recent renovations)
Bank of America Stadium (Charlotte)
LP Field (Nashville)
Silverdome (Detroit)
Lucas Oil Stadium vs. Purdue opening game(Indy)
Fed Ex Field, Washington DC
Tropicana Field - Beed OBrady;s Bowl (st. Pete, FL)
Ladd-Peebles Stadium GMAC Bowl (Mobile, AL)
Rose Bowl, Pacedena
Everbank Field, Jax
Citrus Bowl Stadium, Orlando

Non college (not already listed):
Giants Stadium
Foxboro Stadium
Heinz Field
Texas Stadium (Irving)
Metrodome (Minneapolis)
Soldier Field
Lambeau Field
Ford Field (Detroit)
Raymond James Stadium (Tampa)
Arrowhead Stadium (KC)
Edward Jones Dome (STL)
Univ Phx Stadium (Glendale)
Centruy Link Field (Seattle)




My favorite was Memorial Stadium in Clemson in terms of atmosphere. Century Link was the best in terms of site lines and amenities (some of the above have been renovated since I went). Bryant-Denny is the one I'd like to go to.