I would not go as far as to compare to "drug users"...I mean come on, really?
I think the analogy was a bit off but not by much. From what I can see, there are a number of people who view "rooting" in much the same way that a newbie "tries" heroin. You know, just to see what it's like.
In fact, "rooting" the Droid is no challenge at all. It's the equivalent of getting the password to the root account on a Unix system. Once you have access to that password, however, you can literally destroy the operating system and all that goes with it. Same with "rooting."
I'm not at all surprised that "rooted" users have had mainly positive experiences with adding software or overclocking their phones. What will happen if/when Google decides to make fundamental changes in the O/S, however, is another question. If those changes are made you can bet the farm that they won't be designed to ease the pain for "rooted" phones. They will be based on the assumption that existing operating systems are "vanilla."
Likewise, I'm not surprised to see that the Droid works well in an overclocked mode. At least for awhile, for an undetermined level of overclocking, and for an "average" battery.
I have enough experience with this sort of operation in other realms to be relatively comfortable performing the operations necessary. On the other hand, my Droid isn't a toy that I can afford to be unusable while I try to figure out how to straighten out problems that my changes have introduced or will be introduced by updates in the vanilla operating system.
If it's nothing other than an expensive toy to others, go for it.