Glad you got your system back up and running :)
One suggestion:
in the section [Service] add an entry ExecStartPre=/usr/bin/modprobe nvidia-drm
It may be worth instead adding this to your initramfs for early loading. This is mentioned on the wiki[1], but not really in reference to your problem, so it's not surprising if you missed it.
Cheers,
Paul