There should be no such spell or action which is completely useless in Baldur's Gate 3.
Puting aside that usefullness is relative ...
As far as i know there is no such spell. O_o
If we would say that any spell that have better alternative is useless ... then we would rule out all damaging Cantrips. :-/