In this case you could just use -Sdeps '{:deps { ... }}' right?
Running a REPL with extra paths would be a use case (because :paths overrides the project paths so you need :extra-paths which has to be in an alias).
This would be purely a convenience, to allow for less typing, for a case that folks seem to have grumbled about, on and off, since the Clojure CLI appeared.
And, yes, it's mostly about running ad hoc tooling in a project where you don't want to add it to either the project deps.edn or your user deps.edn.