One non-obvious thing I find it useful for is tacking parts in place for me to then go over with a more structural adhesive, e.g. a slow-curing epoxy.
Superglue can also seal cuts, in a pinch! The thing where it cures instantly on contact with skin is helpful here.
@starkatt bonus: cyanoacrylate is really fun to say
@starkatt Octyl cyanoactrylate is actually used in medical care as a less invasive form of stitches! The ethyl cyanoacrylate that you get as superglue isn't as good for that though, because it's a little more toxic (though still not that bad; definitely do use it if there's an emergency!)