You bet it is. My wife and I made our first trip to CP in May, and are returning Columbus Day weekend for the Halloweekends festivities. We are SFGAm veterans who flipped head over heels for CP. This park has 14 coasters (12 steel), including Millennium Force, Magnum XL 200 and Raptor, all three of which are "top tens" in almost anyone's book (definitely mine). This place is coaster nirvana. Plus, there's lots of other things to do for those non coaster riders for every taste - flat rides, carousels, shows, the beaches, Soak City, Mini Golf, go-carts, Parasailing.......
I highly recommend staying on Point at one of the resort hotels or cabins. Yeah, its pricey, but this really makes the experience at the Point that much better. It's nice to be so close to the park, and it's nice to have a midday break relaxing in the room for a while. After staying at Breakers our last visit, I'll always stay on Point if at all possible. Nothing beats looking out your window after a long day at the park to see that awesome light show bathing the Millennium Force lift hill:)
-------------
First we Rock - Then we Roll!