I've had my SP from new, and anyone that knows me can attest that I don't always treat my car gently.
In fact, it redlines at least once every time I drive it.
My car has done a fair bit of track work and various driver training days, including drift lessons sitting on the rev limiter, and my engine is still 100%.
Not long ago, I had some more engine work done, inclusing increasing the boost to around 12lbs, and it still goes strong.
Quite a bit stronger than stock actually.
I have heard of 1 SP that did throw a rod out of the block, but that car was being fitted with a new computer, and was running on a dyno at full noise, when the mixture went lean and the engine raced and I believe it was revving at close to 9K when the rod let go.
Not something that you could do to a normal SP.
I know of another NB which was turboed, and on it's first drive, one of the injectors was stuck full open and flooded the cylinder leading to hydraulic lock which broke a rod.
Really, the SP's are pretty bullet proof, and if you brought an SE up to the same performance, you would be running the same risk of putting a rod through the block, which is highly unlikely.
Buy the SP, and live happily ever after.