I only ever bought one IDE SSD, the:
Transcend 64GB IDE SSD TS64GPSD330 tested on G3 Clamshell (og Firewire)
- OS9: formatted originally in OS 9(.1?), and booted without a problem.  Used it for roughly 2 years (then upgraded to larger mSATA).  Gamed with it. No problem. 
- OSX: would *not* boot.  It rarely got past trying to load drivers (from install cd, including Tiger DVD off PMG4MDD in FWDM), if I did wait long enough for it to time out (upwards of 40 minutes) it could never write to the drive. Or it would try and fail.  I even tried installing Tiger via Firewire disk mode, but all I remember is I never got Jaguar or Tiger to boot off that drive.  I don't know if it was the drive, or the fact that I formatted under OS 9. 
- Linux (Ubuntu Mate 14.04): booted nicely. Absolutely no problems--with booting.  Configuring Xorg was an adventure.
After upgrading to mSATA, I did not do any further testing with it, but I still have the drive.  I would like to test it on my Lombard G3 (for OS 8.6 and OS X).  And if everything works out, in two weeks I should have a 3400 that I could test OS 7 & 8 with.
As for mSATAs: (I apparently have a thing for them, but let's be honest, popping an mSATA out by just lifting the keyboard is really nice.  I don't want to go back to normal IDE drives.)
Kingston 120GB HDSSD mSATA 120GB mS200: currently in Clamshell iBook (since Feb 2017) with OS 9(latest) and OS X Jaguar.  Boot without a problem.
Samsung 500GB 860 EVO mSATA: (since Jun 2019) currently in G4 MacMini with OS 9(latest) & Mac OS X Tiger.  Boots nicely.
SunBow 128GB mSATA M3 Series: (since Mar 2017) currently in PowerBook G3 Pismo with OS 9(latest) & OS X Jaguar. Boots wonderfully.
Sunbow 32GB mSATA M1 Series: (since Jun 2019) my "OS tester".  Currently has partitions with Mac OS 8.6(untested), 9(latest), OS X Puma, Jaguar, Panther, Tiger.  Tested on Clamshell iBook and G3 Pismo, both work flawlessly. 
Update 1: currently installing Cheetah to test. Because that's what it's for.
Update 2: Cheetah failed to install.  After a reboot I tried to load Disk Utility, but it would not stop pinwheeling (aka spinning beachball), and I gave up for lack of patience.  I have not tried the install cd on another computer.  
Transcend 64GB mSATA SSD TS64GMSA230S (3D Nand): (Since Jan 2020) I own two.  One has a Void Linux install, other has a Debian Buster(?) PPC install.  Tested in Clamshell iBook and G3 Pismo.  Can easily swap between them.  Boots without a problem. 
All mSATAs were used with generic green IDE to mSATA adapters.