Unfortunately I am late for the narc party; but I have input. I was born in the 80s so no fun mind-bending drugs for me, but I can always tell when I am narced; most of the time it is pleasant; occasionally it is more of a dark narc. I can feel the narcosis setting in at 72 ft; I can also hear it, bubbles sound increasingly tinny as the narcosis increases (with depth). Luckily I am consistently aware of my impairment; which leads to tasks being executed in a more finite-state-machine manner until shallower.
Recently I had the "pleasure" of dealing with the increased narcosis one receives when CO2 builds up. It was a wreck dive where the deck was at 134' and the current was ripping. After fighting the current to get down the down line to the shelter of the wreck I had built-up a ton of CO2 and felt extra-narced (really-impaired). I slowed my breathing and after about a minute was much more clear-headed and able to continue on with my dive.
My experience with "dark narcs" has revealed that this is really dependent upon my state of mind when executing the dive; meaning don't dive if you aren't mentally prepared for the dive. I dive very often in lakes, so a lack of visibility, ambient light, and cold water are normal conditions for me to experience. So, diving Puget Sound last year in poor vis and dark, cold water did not lead to a dark narc. Thanks again NWGratefulDiver for the opportunity to dive such a unique area.