It would not be feasible to list every extreme event or permutations thereof, but any kind of power loss would be an undesirable event. Perhaps, it is not clear from my comment, I added a caveat to distinguish between hobbyist or commercial use i.e. in majority of former cases, it might be feasible to find a compromise between price, stability and endurance [0][1].

Further to your link, my experience with Samsung Pro series has been very favourable. YMMV.

[0] https://www.raspberrypi.org/forums/viewtopic.php?t=184696

[1] https://www.tomshardware.co.uk/raspberry-pi-4-ssd-test,news-...