If you only think about the numbers, and say $7000 per season ($500 room+$500 air+ car), I'd guess you'd need at least 3 seasons to pay for a decent used RV. The new BT at the link above would be 8+ years assuming intangible conveniences.
Your travel time will increase, and you still have fees at campgrounds, parking, fuels, etc. How does this equation compare to flying into Indianapolis or Detroit and staying there before and after game day?
Owning an RV is great; it's good to make sure you're not one of those people who take a romanticized view, and learn it's not worthwhile- then park it more than using it.
Depending on your needs, I'd examine a conversion van (like many millennials are), and shower at the truck stop. This chassis is very comfortable for driving, and has plenty of safety features: https://www.explorervan.com/Metris_chassis_options.cfm
PartyOf5 appreciating our Creator thru the created. 5 yrsL 50k, 49 states & 9 provinces.
May you find Peace in all you endeavor.