Here's another category I recently stumbled upon: high endurance SD cards. They are marketed towards dash cams and surveilance gear which typically see higher ammounts of data written sequentially than other use cases. Speed is somewhat irrelevant as long as it's Class 6 or higher (for 1080p), but endurance is king. Reading amazon reviews on dash cams, turns out many folks bought good SD cards, like the Evo you recommend, only for it to fail within a few months, and people recommend high endurance cards (preferably high capacity too to reduce the amount of full disk writes in a given period of time). In the high endurance category, there is a HE Samsung Evo, a HE Sandisk Ultra, etc, and they cost more or less twice the tier you linked. I wonder what the HE cards have technically, to make them HE; I bet they're from the same production line; could they be MLC vs TLC/QLC for the regular or just massively overprovisioned? I'd love to see a deep dive.
Thanks for the explanation!