Nay. I've never liked facial piercings. They're no good if you're serious about pursuing a career that isn't something artsy or otherwise liberal, because people will (stereotypically) assume you're not fit for the job or "clean" enough. And personally, I only really like different ear piercings and alternatively belly button piercings (but it depends).
But honestly, if you want one, go get one. Don't get a piercing just because someone might find it hot, and don't refrain from getting one just because someone else might think it's a turn off. Do it for yourself if you really like it and want one. :)