Technically speaking, a airdrop can't be a scam, because by definition, a airdrop is free coins/token given to you. So coins for free.
But yes, some projects are shady and others are not. And sometimes you can't even know if it's a scam or not. That's unfortunate, but it's like in real business... You can invest in bulshit projects and they will go bankrupt quickly.