I mean truly useful as in it lets you accomplish something that you couldn't do just by sneaking around.
That's a pretty narrow definition of "useful", more like "required". I remember only one place that may qualify: hacking two SGS room doors closest to Tanner's if you don't have Burglar. You could also destroy the camera with a TNT (standing in the bathroom doorway while arming it), but that feels like a bug since normally dealing damage to SGS cameras makes SGS hostile. BTW, Waylon comes out to investigate the destroyed camera, and I like to use this moment to pickpocket his keycard and lock him out of the surveillance room. The same prank also works with Masha at Engineering Level, but you don't even need to destroy the camera, just start doing something suspicious like arming a trap, and Masha will come out to investigate once you're detected (and in contrast to Private Quarters, being detected here won't turn SGS hostile).
Potentially, Camera Jammer could also be needed to steal the Freighter from Ray's pier, but sadly, the weird anti-theft mechanic there allows you to spend only a small amount of game ticks riding a stolen jet ski in the camera range regardless of whether you're seen, and the Freighter speed is capped so you can't bypass this limit even if you install the best engines in the game. You still need Camera Jammer to steal the Scrap Jet since you have to be in the camera range to hotwire it, but there is no reason to do that given that you can steal the Skimmer or the Scooter instead.