I think it can be fun (same with tarot readings) in a lighthearted way and I'm always amused that a lot of things seem to fit (which, yeah, obviously, Barnum effect an all) but it stops being fun when people are a)obnoxious about it and/or b) try to prey on others to scam them out of money.
Re: Astrology