I notice it coming out of a stall etc. But I think it's a) useful, and b) pretty realistic. I'd like to see someone keep their head still with those sort of G's being thrown around! lol
I'm pretty sure if you're moving your head with the stick, it cancels out the effects.
I wish Red/Black outs were more prominent. We're like super humans - we can out manoeuvre a fighter plane. We would be rubbish test pilots!