I agree with your comment about quality hardware. I don't have fancy locking tuners, I only have a vintage Fender Telecaster with old-school Kluson "split shaft" tuners where the end of the string is bent and inserted into the shaft. Once you get used to properly stringing the guitar (it helps if you change strings often), it's not hard to avoid string slippage or going out of tune. The trick is to have enough winds around the post and for the windings to wrap progressively lower on the post until the string leaves the post lower than the nut.
Split-shaft (safety post) Klusons are my favorite tuners, if they're maintained correctly. A little dab of sewing machine oil in the gears can quickly loosen up stiff Klusons.
I'm always stabbing myself on sharp string ends sticking out of tuners. Safety posts really reduce the bleeding in my life.
Here's a great video on stringing up Klusons: https://youtu.be/GqYrXh4D6wI