Not every SSD is of the same durability. The Enterprise grade SSD is more expensive for a reason; it's because they are built to the higher standards demanded by the Enterprise level consumer. YMMV.
I'm not saying there isn't some unreliable junk being marketed as Enterprise grade by shady businesses that pop up then disappear (fly by night), so you have to do your due diligence to research the reputation of the seller as well.
The problem with counterfeit SD's is well known, but it doesn't end there. There are cheap knock-off SSD's as well.
These are what give a bad reputation to SSD's in general, but that's not a fair evaluation. The reality is that cheap SSD's are unreliable, not all SSD's.
The media used in NVMe's is exactly the same as what's found in SSD's. The difference is the interface. The NVMe's are faster because they are not limited by the SATA design. There is nothing about NVMe's that would make them more reliable versus the same electronics in an SSD package.
If you are concerned that heat might result in data loss, then make sure your system has a good cooling system.
Otherwise, the best way to avert data loss is with regular backups. Use LVM so that you can backup your system without taking it offline.