No, I don't think so, you are not just doing the right research I have seen airdrops that are not very popular but have given participants good profit, and there are untapped airdrops.

These are not the tapping airdrops that bring nothing to the community and are only used by unscrupulous developers to make a profit at the expense of the airdrop participants, these airdrops that have good potential are utility-based, they bring usage to the community and contribute to the ecosystem of cryptocurrency technology.

So once you encounter an airdrop ask yourself what this particular airdrop is bringing to the community.