I would suggest staying in the Cleveland area and then driving over to Cedar Point for the day. There is a lot more to do in Cleveland than there is in Sandusky.
When I move I will be living 16 miles from downtown Cleveland and about 40 miles from Cedar Point.