HDDs last best when not moved, as they dont lose the data that much when you dont use them. But they turn around, 24/7. It is insane. They use lots of electricity, produce heat, noise, and wear out without you doing anything.
SSDs have little tear from just being connected to a machine, they just dont do much. To my knowledge they also last longer a lot of times. But they are not as good for permanent storage and should be connected to power every half year or so.
I would always go with normal SATA SSDs, cheap, cool, just work.
NVMEs are so damn hot, small, expensive, often I dont see the reason.