I know a few guys with nitrous DDs, and it really can be a nice setup if you are only looking for a little (or a lot) more umph at the track.
I mean, if you already have a full bolt on/geared car (assuming 99-04 PI motor), it's a low-mid 13 second car, which is plenty fun for the street. Then, go and spend:
$500 on a wet nitrous kit
$200 on a window switch/controller
$300 on a dyno tune (just to be EXTRA safe, plus you get a dyno tune with and without the nitrous)
and BAM. A safe, reliable 400 rwhp car. Still plenty fun on the street even without the nitrous, but a pretty quick car at the track on the spray.
I know several people who have gone this route, and all are quite happy. It keeps the car very driveable (like stock) and (more importantly) manageable on the street, but allows for some nice times at the track on some decent tires. Yea, 400 rwhp all the time would be nice, but honestly, what good is it if all you do is light the tires up 1st, 2nd, and 3rd gear?