Singularity absolutely produces standalone executables, been building tools this way for years.

How? I've used Apptainer pretty extensively for a couple years and as far as I know the machine where it runs has to have Apptainer installed, even when executing sif files like a normal app.

I stand corrected, yes, you need run-singularity to be installed to execute the image, i completely forgotten.