seems just about everyone uses MLC
Usually enterprise grade MLC but still MLC. SLC seems quite rare these days. With several enterprise storage systems putting full support behind MLC on any workload (not just read intensive).
It would be interesting to know what brands of flash are considered good enough. For me personally on my own gear I only use samsung pro or the Intel 7xx series(have one in my PS4). Consumer flash has had too much history of dodgy quality it's hard to tell who to trust most any testing focuses purely on performance. There was one site that wrote petabytes of data onto flash drives to see which would fail that was interesting though didn't seem like a very realistic test. From what I recall reading people commented on how the flash drives would fail during power cycling and I believe that particular test didn't do any of that though could be mis remembering.
Happy to pay a premium for something that is higher quality. Costs are low enough now that it makes sense to me. The 10 year warranty on the samsungs give me confidence that they have more confidence in their product. Even though i can't see myself using the particular drives past 5 years(probably be too small at that point).
I bought one piece of shit corsair SSD many years ago. Lost data on power cycle. Stuck to seagate hybrid drives for a while until the samsung 850 pro came out. Also have a samsung 840 evo to store an image collection. I remember reading about firmware issues on the 840 evo though I haven't bothered to try to upgrade mine it seems to work fine under a really light workload.
On the same note always wanted to see a reliability test of USB flash drives. Never have seen one though sites only test performance last I saw.