Most offensive spells are like this. Tasha's Hideous Laughter doesn't work on creatures with low Int. Magic Missile doesn't work against arcane casters who have a brain in their head. Fireball doesn't work that well against fire resistant creatures. The undead from Animate Dead are crap against enemies with resistance/immunity to non-magic damage. There are few all purpose spells in 5e.
Actually, percentage-wise, most offensive spells in 5E have a lot more utility than Hold Person (there are exceptions like Banishment, but most offensive spells affect creatures in general).
Of the examples you gave:
20-% of all listed creatures: Hold Person
70+% of all listed creatures: Tasha's Hideous Laughter
90+% of all listed creatures: Magic Missile (including dragons)
92+% of all listed creatures: Fireball (96+% if we are only talking immunity)
75+% of all listed creatures: Animate Dead (and only some of the most powerful creatures like demiliches, liches, and the tarrasque are immune to weapon damage, so Animate Dead is almost always applicable 99%, it might not be the best choice, but it is almost always a choice)
Granted, in a campaign where the PCs mostly interact with human, elves, etc., Hold Person's utility increases. In those cases, however, PCs tend to not cast Hold Person on most of those NPCs, so it tends to be self limiting.
But a low level Wizard can prep Hold Person and never cast it for an entire adventuring week. The same typically cannot be said of Tasha's. Yes, damage will typically negate Tahsa's, but even if it does, that's still about nearly as much time as Hold Person usually lasts, it just has a much higher number of potential targets and does not result in melee crits. The target is still prone until its next turn which allows multiple PCs to still melee attack with advantage.
Our 6th or 7th battle of the day, we had a level 3 Fighter, a level 3 Monk, and my level 4 Necromancer and we fought against 3 bugbears and we dropped one of them in less than a round thanks to Hold Person.
The same might have happened with Tasha's.
But if it had been 3 Specter's (or a wide variety of other CR 1 creatures), Hold Person wouldn't have helped at all.
Note: To be fair, Hold Person in higher level slots is amazingly powerful against multiple humanoids. The odds of at least one NPC failing multiple saves is high. For example, a level 4 Hold Person against 3 humanoid +0 Wis NPCs has a 96% chance (or higher) of affecting at least one NPC and a 81% of chance of affecting at least one NPC for more than a round. But Hold Person at second level can easily fizzle though and there goes one of the low level Wizard's big guns for the day.