Have you ever taken a personality quiz/test that helped you have valuable insights? If so, what were the tests and how were they useful?
The only useful ones I've found all yielded the same type of insight. They showed me where I stand relative to others, which is can be genuinely useful since representative samples of large populations can be hard to come by. This includes IQ tests and tests for mental disorders (in my experience, people are usually aware that they are, for example, smarter than the average (although the Dunning-Kruger effect might complicate this) or have some intrusive thoughts and compulsive rituals, but might be surprised to find that they are three standard deviations above the norm or that their symptoms are sufficiently severe to be considered OCD).
No remotely reliable (as in, not astrology) test I have ever seen has revealed genuinely surprising information for a moderately self-aware person, outside of ranking. Furthermore, they rarely gather personality data in a remotely subtle or non-transparent way ("do you like spending lots of time with large groups of people?" "yes..." "surprise, you're an extrovert!"), and thus seem super susceptible to test-takers' attempts to confirm a desired identity.
An example of a more interesting/subtle way to potentially conduct a personality test would be to use question like OKTrends' "do you like beer?" which clusters strongly with "do you have sex on the first date," and, potentially, sexual openness. Such results might be harder for manipulate (consciously or unconsciously) and could assist with deeper self-awareness.
Edited because the first link was broken.
Given that most of astrology is about giving someone very vague statements that can be interpreted in any way you want, if you do get surprised by an astrology test of yourself that might mean something.
As far as I understand most of the personality tests that get used for job interviews are of that nature. Someone who wants to hire a candidate wouldn't use a test that's easily faked by the person taking the interview.
Those tests seem to be good enough that companies are willing to pay money for them but of course that doesn't mean that they are more than cargo cult practices.
It might mean you're unusual. Did you have something particular in mind?