I'm not a Cleveland native, but I lived there for a few years. While it's certainly not a garden spot, I wouldn't go so far as to say that it doesn't have any redeeming qualities. The summers are really quite pleasant and for a city of its size, the traffic is light. Its symphony is among the best in the world and, as someone mentioned above, its hospitals, particularly the Clinic, are world-class. Once you get out into the suburbs, the beaches (for a lake) and the parks are quite nice.
I'd also note that other than the winters, which are really just an inconvenience, it's an excellent spot on which to build a city. There are no floods, no hurricanes, no tornados, no earthquakes, and it has access to one of the largest supplies of freshwater in the world.
Cleveland has two major problems: the winters and the taxes. In Minneapolis, many of the buildings downtown are connected by tunnels and skywalks so as to keep people out of the cold in the wintertime. Cleveland should do this but, to my knowledge, it has no plans to do so. It should also improve access to the lakefront downtown. The lack of an accessible lakefront is embarrassing (it was also a mistake to put Browns Stadium on the waterfront). Lowering taxes would be a big improvement, too.
The lakefront in Cleveland is arguably the most valuable piece of property between NY and Chicago, and on it is a football stadium used ten times a year, an airport used primarily by corporate planes, and a lot of vacant warehouses. Of course, having I-90 running right by the lake cuts off the rest of the city from lake access.