I've been to Cleveland and it's actually a pretty solid place to live. I would argue you could have a far better life there with a $50k house than slavishly working for the rest of your life for a multi-million dollar tiny home in a giant sprawled out suburb.
FWIW I never met a single person in the bay area that didn't want to live basically anywhere else, but couldn't because of work (and access to work). I'm sure they're there but I never met them. Networking is going to be terrible during COVID too, which is arguably the best thing about being down there for a startup anyways.
I just think people are going to be amazed at how much that place hollows out as more tech companies decide to permanently go remote. I loved the weather, but I also like not having to work as much to put a roof over my head. I'm sure that resonates with a lot of other people too, that don't think retiring early surrounded by friends and family is a prison sentence.