I live about a half-hour away from Cedar Point.
If you're looking for something else to do while your in the area, you have a few options:
Take the Millersburg Ferry or the Jet Express to Put-in-Bay, a small island a few miles off the coast of Lake Erie. There's quite a bit to see and do there. I recommend renting a golf cart and just driving around the island. At night the island gets very party-like-- I'm not sure if that's your thing or not.
If you're looking for someplace a little more laid back, try heading up to Kelly's Island nearby. You can rent a bike and ride around the whole island looking at the scenery, stop for ice cream, and then take a dip at the public beach.
Obviously a little further away is Cleveland-- you can head downtown and visit the Rock & Roll Hall of Fame, visit Severance Hall and listen to one of the world's best philharmonic orchestras, or spend a few hours at the Museum of Art (which is absolutely free), the Natural History Museum, Crawford Auto Museum, etc. etc.
You probably already know this, but the football hall of fame is in Canton, about an hour south of Cleveland, and an hour and a half away from Cedar Point-- but if you are a football fan it is a must-visit.