Enterprise drives are quicker then consumer drives. As well as how they deal with non-compressible files, encryption, monitoring / report and other enterprise features and of course warranty.
In terms of write cycles techreport has been running a long term test on consumer drives,
You can see that TLC is starting to get increased failures past the 200TB of writes to a 250GB drive. MLC still going strong past 300TB of writes. And as long as wear leveling is working then you can 4x these figures for a 1TB drive so expect at least 800TB of writes for a 1TB drive.
As for the 840 EVO, the software is interesting. RAPID driver uses RAM for caching potentially giving some PCIe SSD level performance depending on what apps you are using. I'm running a MySQL app on a development PC and experiencing some pretty decent performance improvement. Also potentially reduces writes to the drive. Shame the driver doesn't work with linux or Windows Server.