Nitrogen Narcosis isn't something that (in my opinion) is a HUGE danger in recreational diving to 130ft or above. But it is something to be very aware of. The most I've been narced is at 159ft. I know that is below the normal limits, but it was a wall dive and I was new to deep dives. At that point, all I can say is...I thought I was flying and everything was sparkling. I completely forgot I had a limited amount of air, or that I even had gauges (hence, the 159ft!) Luckily, I was diving with my boyfriend, who grabbed my tank valve, pulled me up and shook me...which got my attention!
Narcosis isn't a build up of nitrogen intake. It is nitrogen breathed at depth. It is an immediate "feeling" that will go away once you accend a few feet, or usually, once you realize "hey, I'm feeling messed up!"
If you dive at 30ft for 2 hours, the nitrogen won't stay in your system and cause Narcosis. You may freeze to death...but you won't be Narced.
There is real no depth limit for Narcosis. I've felt narced at 60ft before (and NO, I'm not blond!!) Basically, if you are doing the "la-de-la-de-la" thing...not checking you gauges, not checking your compass, not caring WHERE in the deep blue sea you are...THAT is the behavior you have to worry about.
I also experienced the "paranoid" narcosis once. NOT a good thing. I wasn't in a good mood to begin with, and did a dive down to 142ft (same wall dive) and I just felt like I was going to freak. But, I had (regained) the sense to know I couldn't just GO up to the boat..and that I was "feeling funny". So I went up about 10 feet at a time, until I felt like myself again (actually, I was PMSing at the same time so it took a few days!)
But, alot of getting narced depends on the person, and the day. Alot of people think getting Narced is a cheap high...but doing it on purpose is dangerous. It is only really dangerous on deep dives because that is when most people feel the effects.
Ok...think I've rambled enough here...
Hope this helps Gary