Getting there is easy. From Cleveland Hopkins Intl. Airport in Cleveland, Ohio, take Interstate 90 westbound to state route 2 till you start to see the signs for Cedar Point. From the airport you are only about 45 minutes away.
As far as hotels go, there are like 6 hotels within a mile of the park and these ones get you in an hour early and are all nice, the nicest hotel is called The Hotel Breakers, which is on the beach of Lake Erie, and you can take a beachside sidewalk to the beach entrance of Cedar Point. The beach is amazing and this is a wonderful hotel. The area is very, very easy to get around and the park is a sinch to navigate.
Hope you have an amazing time!