Hopefully related: If I'm a photographer wanting to improve resolution of my content for printing, what's my current best bet for upscaling?

Is it realistic to make use of this on the command line, feeding it my own images? Or has someone wrapped it in an app or online service?

If you have a Nvidia GPU, I've been using Upscayl locally and for free with decent results: https://github.com/upscayl/upscayl

Note that on some image types it tends to make things look digitally painted rather than detailed. I recommend you try a few different tools and see what works best for the type of photography you do.