> Systemd user services need absolute paths

no, you use the specifiwr %h instead of ~ here is the expensive list of specifiers https://www.freedesktop.org/software/systemd/man/latest/syst...