I've been narced twice. Once, at 80' on Columbia Pinnacles, I felt paranoid, as in "What the hell am I doing here?". Not afraid, just very edgy in an amphetamine type way.
Then, there was the devil's throat dive. I was with two guys who had shaved heads and who I didn't really know, along with the DM and another diver. We got a little separated in the tunnel, and they disappeared due to their having zero frog kicking skills and managing to silt up the whole place. I couldn't find them for a second, and started backing out. The other diver behind me kind of pushed me ahead and indicated a left turn. Then I saw two members of the Hitler Youth crossing in front of me, in Scuba Gear. I wasn't frightened or confused about my dive, I just thought "What the hell is the Hitler Youth doing at Devil's throat, I didn't see another boat". It was weird as hell. No feeling of drunkenness, just a delusional belief that I had somehow gotten mixed up with the Hitler youth on a dive in Mexico.
When I posted this before on another board, people thought I was kidding. I wasn't. I guess I should point out that I am not Usually Psychotic, take no medication, and have no other delusions that I know of. If you search all the standard books about Narcosis, they sometimes mention delusions. So, that's my story on being Narced.