For me narcosis presents no noticeable feeling whatsoever. It just presents itself as stupidity. When I have been aware of it, I have had an occasion to do something that demonstrated that stupidity. In each case, if the situation that demonstrated my stupidity had not occurred, I could have easily completed the dive and sworn I had never had any effect. I have never had a situation arise where I had to do something serious, like a life-or-death response, while under the effects of narcosis. I hope I never do.
A couple of years ago, a dive shop owner in Cozumel and two friends decided to do a quick, one tank bounce dive to 300 feet. Narcosis is usually given as the explanation for why she continuing descending at 300 feet and was not caught and turned around until she had reached 400 feet. She died from the resulting DCS, and the friend who caught her and turned her around will never walk again.
That buzz can have negative consequences, so, like Lynne, if I want to experience what is often call the "martini effect" of narcosis, I prefer to do it with a martini.