Agreed with everything here. A "realistic" upgrade for CCSU is simply playing in a football league alongside URI, Maine, and UNH in moderately improved on-campus field. Basically most fans would be ecstatic with an Arute Field upgrade to about 8-10k that looks something like UConn's Morrone Stadium - that's it. However, even these very moderate dreams are unlikely to come to fruition anytime soon.
FYI - My understanding is the property CCSU/State owns in Newington across Route 9 and alongside the Busway (once proposed East Campus) is basically unbuildable. Environmental issues and challenges connecting it to the rest of campus means it will likely stay unimproved for decades to come. There were concepts/proposals for a new arena to replace Detrick and some campus housing, but the University and State were unable to get the necessary funding and approvals.