One important thing with SSDs is that many even today aren't great with power loss detection.
Kingston makes a very reasonably priced data center class SSD with lots of RW cycles and specific power loss protection. I haven't tested them yet, but it's a good sign they at least mention it in their specs. I previously used intel data center class SSDs, but they're harder to get ahold of these days.