I've use nitrous over the past 10 years on different car. My first setup was a dry kit on a Toyota 22R-E (in a modifed 4x4) to do mud drag. This was jet to 60hp and never ever had a problem.
My second setup was a dry also on a 5.0l mustang. I've use it over and over without problem.
As previous stated, never under 3000 and never close to rev limiter. the safest is to use with rpm switch and full throttle switch.
It give good result, as it is use only when needed, put less strain on engine that supercharger.
I'll go for a wet kit this time on my 2ZZ-GE, and confident that i'll have no problem. Small 50hp gain.... and mostly huge torque gain
Most bad story about nitrous is due to over jetting, bad install, use at improper rpm and/or lack of fuel. If you get fuel pump problem this will cause severe lean condition...
This happened to one of my friend Suzuki swift GT and it melted the valve...
but anykind of force induction can cause problem, some people that say don't use nitrous it's dangerous, have never in fact use by themself.... this is like a big urban legend...
They wont sell that much nitrous kit if it was so bad
I give my

to nitrous...