I think that would make sense if the stadium were used weekly for something. I don't think making major capital investments into a structure rarely used makes financial sense. That's the problem with the stadium being where it is, and it is a rental. It doesn't enhance the Storrs campus and it has very limited use so spending big bucks for all the bells and whistles just does not make sense. I like it for tailgating and watching football, it serves the purpose well. But that is all it is.
I spent some time in Athens, GA for work so I would jog around the campus. One day I ran across the Sanford Dr bridge which overlooks the end zone and there was a small ceremony of some sort in the middle of the football field. A great setting. Sanford Stadium is pretty much Athens, GA. It is squeezed right in the middle of campus. That is how serious football programs do it, like it or not. I hope UConn gets to that point.
i don't think you're wrong. It would be a 'waste'.
TBH no modern football stadium is worth the money the universities spend on creating them. When does Michgan need to put 100,000 people together, besides 6 times a year? Tennessee? Penn State? etc. etc.
It's kind of like that picture i saw once on IG about LSU's new stadium upgrades and locker room upgrades, but they had a leaky ceiling in their library that was being dealt with, with garbage bins catching the water.
But unfortunately, this stadium discussion isn't about money spent being "worth" it, in the way you're outlining above.
so, assuming that spending your money on football stadiums is a waste of money (in the grand scheme of life, it is 100%),
UConn either wants to be relevant in FBS Football or not. In addition to wasting money on players, they need to waste some money on playing in a home worthy of a power conference badge (BTW The Rent
was worthy... 17 years ago).
there are counter examples to this (power schools with not amazing stadiums) but those are fewer and fewer as the years go on, and they're legacy programs who were lucky enough to be grandfathered into the power status (northwestern, Vandy) - but see, even those schools are choosing to "waste" their money on keeping up with their peers and making modern gameday experiences.
If we behave like a Big East school in 2024 we're gonna get treated like a Big East school.
If we behave like a Big 12 school.... etc.