Trying to troubleshoot a systemd service that won’t start properly is such a PITA. There should be an interactive tool for setting up a new service and seeing exactly what’s going wrong.
Maybe even better a tool where you feed it something that works perfectly fine from the command line and the tool will generate a working service.
Dreaming.