They are still quite stunning and interesting to see, IMO, but an astronomer told me that the spectacular colours you see in photos and on tv are generally added post-production.
I agree. I have seen them many times and usually, they look like pale curtain that is whafting backwards and forwards in a breeze. They are usually pale and white. I have never seen the bright colours that you see in photographs.