In the specific case of Samsung consumer vs Enterprise SSDs, the differences are:
1: Write endurance - The enterprise drives will handle more writes
2: Powerdown protection - If the juice goes off, they'll flush their buffers
3: Guaranteed write latency - many consumer grade drives end up pausing for a few tens or hundreds of milliseconds every so often whilst they do wear levelling. Samsung's enterprise drives don't do this.
4: Spare blocks - the enterprise drives have a lot more of these.
5: Better internal error correction - the industry standard 1 in 10^14 bits works out to one uncorrected byte emitted from a drive every 5-8Tb of reads and based on what I see in my disk arrays that's about right. Moving to 1 in 10^15 is ten times better etc.
All Samsung drives use MLC or TLC technology, even the enterprise ones.
Whilst SM or PM-series drives are are significantly more expensive than EVOs, bear in mind that EVO drives are designed for light duty write cycles and may suffer more from write amplification - experience in the consumer sphere shows that most people fill drives with static content (photos, etc) and leave them for long periods - a occasional bit error here or there in an image doesn't matter. It does in a spreadsheet (which is why you'd use PRO drives) or when crunching large quantities of scientific data (which is where I use the enterprise drives)
Comparing the consumer -PRO range with the enterprise range shows a 15-25% premium which for many uses is justifiable (unlike spinning media where an enterprise can be 3 to 4 times the price of an equivalent consumer drive and Backblaze is quite right in their assessment of mechanical drives)
I'd be happy to drop EVOs in a desktop or games machine, less so if I was using it for business purposes. If hammering the drives then enterprise models are the way to fly - but consider something like a ZFS array with SSD cache drives (eg: FreeNAS) as this would be much cheaper and suits many modelling processes where only a small segment of data is being worked on at a time.
No matter what, when you have these quantities of data, back them up. RAID only protects against some kinds of hardware fault, not accidental deletion or catastrophic events.