Lots of info to consider here ( I was a transplant my self 24 years ago) .I'd start with what side of town are you moving to? Do you mind driving to the boat?
In our case we live east, but the boat is west , due to the marina, places to go etc ... but most people think we are crazy to drive an hour to get to the boat ( it's a Cleveland thing) ..
Kind of depends on what you are looking for .. a club? lots of sailing? Places to
cruise to ? Even down to the economic profile of your fellow
dock mates- it can be shockingly different.
I will say , it's a great area don't listen to the haters.. Cleveland is not what it was- downtown is awesome, we are a serious world class restaurant city , the lake can give you pretty much much anything you can want ( except being on it all year)
And this is real - if you can sail Lake Erie, you can sail anywhere...
Let me know how I can help , and welcome to the North Coast !