Most all SSDs out there now are ultra reliable.
Intel had their own failures a few years back, just like nearly everyone else. Bugs in the firmware.

I generally suggest Crucial M4 drives for the paranoid now, or the ultra-expensive Intel ones for the paranoid + wealthy.

Personally, I'm using OCZ Agility-3 drives now. They're rock solid for me here, and the only issues with them in the past were with MS-Windows-7 users in Nov-Dec 2011.

For PATA SSDs, there's not much choice. The Transcend ones that are linked in this thread are probably the best bet. I think "KingSpec" also makes some. But it's pretty unlikely that any of the PATA ones will have modern high-performance controllers inside like their SATA brethren have.

High speed (480X-600X) CompactFlash cards also exist, and many are about the same speed as the Transcend PATA drives, and probably have equally good/bad/identical controllers inside. CompactFlash is equivalent to PATA, but in a smaller form factor.