Do they plug n play and work like any other standard IDE? First time in my life i ever heard of this and i had to pull some up on google to see if you were joking. I thought anything for IDE has been dead for a decade. The more you know i guess.

Very freaking cool
Yup. You can either get an IDE unit or an adapter bracket. I like to get these kits from OWC, that way if the SSD dies, you can just replace it with an off-the-shelf SATA model:
https://eshop.macsales.com/item/OWC/SSDMXLE120/
Note that there are two standards employed for these older connectors: Desktop IDE & Laptop IDE. Desktop IDE have 40 pins, whereas Laptop IDE have 44 pins - the extra 4 pins carry power, to replace the Molex connector you'd find on a desktop power supply. So you'd need something like a Transcend or KingSpec 44-pin PATA SSD if you're going to replace a laptop or a slim desktop that has a 44-pin IDE connector. Regular desktops can just use an adapter bracket, which I prefer because unlike mechanical spinning drives, SSD's tend to just straight-up die instead of slowly degrading in performance, so it's nice to be able to quickly swap it out instead of having to get a special part.
You're still limited to the bus speed, but it's typically quite a bit zippier not just because it maxes out the bus with the SSD, but also because you remove the latency from a spinning drive. Plus they're a bit more reliable, especially in things like laptops, where a spinning drive tends to get damaged from all the moving around of the computer while in operation, especially as most of the older drives don't have any kind of free-fall sensors in them to park the spinning head the machine is dropped.
I do work for a lot of smaller shops like restaurants, healthcare facilities, and shops where they just don't have the budget to go out & buy new stuff, or else they're locked into using older hardware & need to keep it running on the exact system version & hardware interfaces that it was originally shipped with, so there's still a pretty good market for up-cycling old stuff!