This is a yearly vacation spot for our family and we have recently found that the Comfort Inn in Sandusky offers a great package including tickets to the park, etc. There is also a KOA campground outside of the city itself which offers packages for the park as well as the surrounding areas.
There is presently a pretty good deal for their Halloweekend. Park tickets are being sold for $25 when rooms are booked at the Castaway Bay. An overnight stay at Castaway Bay stats at just $79* per night plus tax. Tickets and reservations can both be booked on the Cedar Point website.
The best package deals for Cedar Point are found on their website for the hotels located on the property: Breakers Express, Castaway Bay and Sandcastle Suites.