I love CP and have gone every year for the past five years. I agree with what others have said, its a good mixture of thrill rides, family rides, and classic rides (CP has 3 classic carousels). My personal favorite rides are the Denzel Kiddie Kingdom Carousel, The Racer, The Sky Ride, and Gemini. It is a huge resort area, and actually its not all about the park. They have a water park there, as well as a beautiful sand beach that never gets used anymore, but does have a place you can go parasailing. There is also a marina area, which has a few restaurants.
I have never myself camped at a park (not a bad idea though) but I know CP has two onsite camping facilities,
Lighthouse Point, and Campers Village. You can check the rates online at
www.cedarpoint.com. Both are walkable to the challenge park gate of Cedar Point (campers village is a little closer), and if you are looking at cost, that's major as you are saving on parking, which I think is now $9.00 or so.
Also if you do stay onsite the park offers early mornings, where CP opens select attractions 30 minutes early for onsite guests, usually the list consists of Raptor, Millinnium Force, Top Thrill Dragster, etc. This is a life saver especially for MF and Top Thrill, which can easily have 2 hour plus lines in the afternoons on busy weekends.
As far as overall cost, if you can get a season pass from another Cedar Fair park you can also use it at Cedar Point to get in free. Some are better deals then others, you can look up the entire chain at
www.CedarFair.com
Jennifer