Enterprise grade spinning drives are ideal for backup.
Good hygene is to have a bakcup of your backup stored in a different location.
The downside of enterprise grade drive is that they can be noisy so I don't use them any computer that needs to be quiet.
SSDs are faster, dead silent and the preferred solution for pretty much any form of computing.
NMVE drives are faster than conventional SATA SSDs and ideally suite for storing the computer OS - provided the motherboard supports it. However, its worth noting that some motherboards have an M2 form factor drive slot but it may not be NMVE compatible.