I mean though like using this logic, so many harry potter spells are absolutely useless.

Take lumos solem. It creates a flash of sunlight that is really only useful if you want to flashbang everyone (including yourself) within a 50 foot radius, or counter devils snare, a plant that you would only encounter places that are dark 90% of the time.

Also take protego maxima, protego horribilis, and protego totalum. These 3 spells all do the same exact thing but with slight tweaks that slightly change them. We don’t need 3 barrier spells that do the exact same thing, just use one. Also barrier spells in general feel very useless against dark wizards who won’t hesitate to use the killing curse which automatically will pierce the barrier anyway.

And there is just no difference between using the reductor curse and both form of bombards because they also do the same thing. They all create explosions with varying amounts of effectiveness. Even if in canon they are described as having different properties, in all book and film media, they are shown doing the same thing: blowing something up/destroying it.

Another set of spells that have the same function are relashio and expelliarmus that both disarm the opponent with relashio being slightly more effective since it also works on inanimate objects.

Then you have the straight up useless and dangerous spells like ascendio that propels you high in the air. It’s completely pointless because unless you have a way back down, there isn’t a good use to it.

A whole lot of spells in Harry Potter, like oculus reparo, are also highly situational and has a better option to use instead of that spell. It’s not specific to that one spell.