Its very fun! IF you ride at night, ride in the VERY back, and have a FP or don't wait more than 25 min. Its zippy, got some good drops, and its fun! We are born and raised on Cedar Point, LOVE Busch Gardens (who for us is the king of rides for Orlando currently) and still enjoy it. My 38 yr 6'3 husband gets 7D FPs on his own for us (and of course, we wait for the back), which pretty much tells me all I need to know. Its not a HUGE THRILL, but it is fun! I think a perfect MK day for us consists of FPs for 7D, SM, and either Splash or Thunder (either of the two). That's a perfect day for FPs for us.
Still, if Cedar Point is his style, you seriously should consider taking a day at Busch Gardens, because its amazing, the park is huge, and in my opinion, between Falcon's Fury (the freakiest maybe of any ride I've been on, including CP) and the super fun Cheetah Hunt and 100% PERFECT Sheikra (how can a ride be 'perfect'? Ride it and you will see what I mean.), it will be as fun or more than Disney. And the animals are wonderful! The giant refillable drinks for $1 are great and it you like rides, this is your park. And if you don't like rides, you will still have tons to amaze you. (The Lorrie bird house where they fly all around you, the incredible A/C enclosed tiger encounter where you can sit and relax in the heat of the day and watch the tigers, the SkyTram which Disney no longer has, etc.)