I loved Cedar Point when I visited it last summer. It was a very charming park, and as others have pointed out, it's got a lot more going for it than just the coasters. Being the adreniline junkies we are, my sister, cousin and I were at first just plain excited about the coasters. But when we got there, it was even cooler - we were right on the beach, staying at the oldest hotel on site, Hotel Breakers, which was beautiful (although the rooms could use a bit of renovation). It was very relaxing when we first got there, we didn't go to the parks that day. As it was a family affair, my brother and my cousin's father and his girlfriend came as well.
Point being we made it a family vacation, and that included my cousin's 5 year old. So I think people discredit the resort far too often. There's more to the resort than thrill rides, and it certainly isn't another "Six Flags" type of park. It has a history to it, and it's a fun resort to visit. If we were going back up the east coast next summer, I'd bet we would do it again.