I graduated in '14 so things may have changed slightly with the addition of the Storrs Center but not by much I'd bet as I was there for its first year open.
You can't really know whether UConn is good or bad until you visit and compare it to similar tier universities. You look at any other major state university with a student body size similar to ours and it's not even comparable. Maryland, UVa, WVU, OSU even UNH all have entire streets and downtown areas with bar after restaurant after bar, and this doesn't even include the southern state schools which are just on a whole different stratosphere. Every college town bar has drink specials so that's not really a counter-argument or selling point.
At UConn you have Teds which can fit maybe 60 people before it becomes a miserable experience of bumping shoulders and lack of oxygen. Huskies is an extension of the Greek life scene with a slightly larger setting but not by much. And then there's Thirsty's which was my personal favorite and has changed name and ownership recently, but the point is three bars is not even close to what UConn's competition is working with, I repeat, not even close. Hell, even Syracuse which is a miserably depressed city has an infinitely better bar scene than us.
One major problem is that all this is happening in a town with little else for entertainment for the 18-22 year olds that keep the economy afloat, and local non-student residents who seem to resist any form of commercialization. No public transport and an administration that over the last 10 years has actively tried its hardest to destroy any off campus party scenes and have done so successfully to a certain degree, combine to aid the problem.
Let me ask you this hypothetical question. If a travel/food show like Diners, Drives and Dives came to the UConn campus, where could they go where it wouldn't be embarrassing for us.