I suppose you guys have never heard of the term "Italian tune-up?"
1996-1998 (OBD-II models) Porsche 911's will throw a MIL for air passages that are blocked by carbon buildup. It appears that owners that baby their 911 are more prone to carbon build-up than 911 owners that open up their 911 from time to time or track their 911. [Digressing...] Some parts of North TX require emissions testing and a MIL is an instant failure. The fix for that air passage carbon buildup is a $7-9k top-end rebuild. Suck-o-rama.
IMO, it's actually good to open up your car from time to time to burn off any carbon deposits that may build up. The best way to drive your vehicle is to drive it "normally." Don't "abuse" it, but certainly don't baby it either.
For NISSAN's, the redline isn't really the actually point of failure. With the VQ, if you stay 500-1000rpm above redline for an extended period of time, then you will certainly get valve float and/or destroyed bearings.
I don't even know how you can get the engine to go into the redline, other than going down a long steep hill at 150 mph and even then, I wonder if it would.
I've always considered the tach to stop reading rpm at the redline and start reading in $, but even then, redline is a guideline to safety for the engine's life and is set lower than where significant damage would occur quickly. Hitting redline wouldn't bother me. Hitting 2,000 rpm above redline would start to concern me. Those valves need enough time to get out of the way of the pistons! Other than that, the VQ is built so well, I'm not even concerned about bearings being one of the first things to smoke, pop or crack.
I think the computer does a good job of protecting the engine.