It does glow sporadically like the Evil aura. I've only had one Mystic fortune teller before, and unfortunately the only thing her aura did was degrade her relationship with genius (and/or maybe eccentric) sims every time she glowed. It got to the point I kept having her quit the job then slowly climb back up to level 10 only to quit again, because her aura kept turning those family members into hated enemies!
It's possible it makes sims with different traits happy, but I'm not sure about that. It is pretty though!