>clean, vibrant downtown area, ... good transit (including lightrail), a diverse economy
The city is extremely dirty and constantly has a very bad smell, and the RTA (public transit) is a disaster. The direct downtown area is essentially just a massive parking lot. The economy also consists entirely of the Cleveland Clinic and a few other large health care corporations. Not exactly what I'd call diverse.
Other than that it's pretty average, there are fun things to do but you're going to run out fairly quick.