I can only review Cleveland as a tourist based on my short visit to the City.
I found the City quite tourist friendly with a decent public transportation that I can use during my stay. It is always nice to able to have a pint or 2 and without worrying how to get back to my hotel.
People were pretty friendly. I though a little confused with the empty roads and trains even at rush hour. Everywhere was never too busy. Maybe I came from bigger cities where everywhere was jam packed with people and cars.
Having NBA, NFL and MLB teams. Sport fans would not be disappointed as it is always fun to catch a good game.
Beers and more beers?! A week long Cleveland Beer Weeks?
There are also some nice interesting restaurants for some decent meals at a good price point.
Hotel rates Downtown though was really pricey, probably due to supply and demand as there are not too many downtown. But as long as you stayed in one of the hotels near Red Line, then it is easy for you to get down with just 1 train.
Cleveland is not a big option for a weekend stay or a mini getaway. But may not be a "destination" as a vacation hot spot.