I have a Spec lightened flywheel/stage 3 on the MSP now.. The "adapt your driving habits" thing sounds intimidating but the difference wasn't that drastic. The car did move up the rpms quite easier, but after it was installed, a few engine issues came up so I never really romped on it hard enough to be able to justify the differences.
The tranny, as a whole, did feel quite solid... But that's with a KB SS, KB shifter bushings, CS bronze bushings, Royal Purple tranny fluid, Spec stage 3 hybrid clutch, Spec lightened flywheel, and another unmentionable mod.
I'd say get one.