Only 5 more sleeps until CP opens...wanna guess where we'll be comes Saturday???
Anyways...LOL....to answer at least some of your questions.
I've only ever stayed at Breakers Express and for our family and the amount of time we spent in the room, this was just fine. Its nothing fancy but its clean, spacious and comfortable. Its located on the causeway, so you'd have to take your car but it would include free parking and you could come and go as you please. I like the idea of staying at Breakers or Sandcastle Suites but I just can't justify the price. We've also looked at
Lighthouse Point but those are grossly overpriced as well. Staying on Point allows you to take advantage of ERT and this can help with getting in some coasters before crowds set in. I would recommend Maverick if you decide to stay on Point as the lines seem to be the longest for this.
I've also stayed at the Fairfield previously mentioned and it was nice as well. We loved our stays at both Great Wolf Lodge and Kalahari. But in my opinion, if you are paying to stay there (especially Kalahari) its a waste to not spend time in the waterpark. Especially when there are cheaper options.
Depending on traffic, you'd be from Fairfield (the furthest away) to Cedar Point parking lot, within 20 minutes depending on traffic. Getting down 250 can sometimes take a bit with traffic. 250 is the main drag in Sandusky and you will find pretty much any place you want to eat or shop along that drag.
If you stay off Point, you can leave one time on your parking pass and return later in the day. Anymore then that and you will have to pay the parking fee again. Parking is $10 again this year. Be sure to get your hand stamped if you leave too! Cedar Point has 2 really nice picnic facilities on either side of the admission gates. Lots of people grab Subway and McDonalds (theres one on the Causeway) and eat at the tables.
I know absolutely zilch about Cleveland other then to get there we take the pike and the R n R Hall of Fame is there and the Indians, Browns and Cavs play there

I've been but it's been years, so I'm sorry I'm no help there!
If I can help with any CP questions, let me know. I know very little about Disney but I know CP inside and out!!! Have a fantastic trip!