Shockwave in ME2 was only useful against husks and abominations. Against them it was devastating. You could take down a dozen of them at range, maybe even blow up the abomination and cause even more damage.
Against every other enemy it was pretty much useless like you say. But I'm sure ME3 has some kinds of husks :D