There is no "worship" of Scorpio. I challenge anyone to cite a book or article, or to link a credible professional astrologer who says such a thing. There is a branch of evolutionary astrology that seemed to deify Aquarius (Age of Aquarius) and Pisces (the final sign) but this sort of dates back to Dane Rudhyar and the 1970s.
So let's get clear.
Scorpio is the fixed water sign. They can get really determined upon a particular course of action, but probably no more so than the other fixed signs (Aquarius, Leo, and especially Taurus.)
As a water sign, Scorpio tends to be intuitive, but no more so than the other water signs Cancer and Pisces. A Scorpio might expect another sign to pick up on subtle cues. A Cancer or especially a Pisces would be able to do this, but an air or fire sign would be hopeless.
Scorpio is traditionally ruled by Mars and modernly by Pluto. This can make them pretty aggressive when they want to be.
But there is no "worship" in any of this. Scorpio in many ways is a difficult sign. I don't envy them. They do not seem to have the personal boundaries of other signs. Sun Scorpios tend to find out who they are by pushing their limits with other people. It requires the other person to say, "stop" to get the Scorpio to learn where those boundaries are.
Scorpios do seem to have a sense of revenge, but to them, it is merely justice: tit for tat. If a Scorpio seems out to get you, just pause and reflect upon how you might have offended him, however inadvertently. (Given that this is a water sign, Scorpios can pick up your vibes even when you're not directly in their face about something.)
What seems to be far more obsessive than Scorpio is someone with Pluto squaring his sun. Something to think about.
