I think almost everyone is a follower. Even presidents follow the law and their backers. CEOs still need to follow what the markets and customers want. I think the persons that don't need to follow anything or anyone are dictators and tyrants.
I don't see what's wrong with following. The human civilization has survived because people were smart enough to follow smart people. Those leaders listened and followed from those before them.
Psychopaths...
There is nothing wrong with following at all. There is also times we might need to lead, so we should learn how to do so. Parenting is a good example that comes with many instances for leadership needs.