I went through a rough patch from 2002 to 2009 and couldn't afford new hardware, other than when I was finally able to get a second-hand laptop.
Before the laptop, I'd go visit customers with my pc tower and ask for peripherals when I got to their office, fun times. Well, not really, but I can laugh now ;)
I don't recall the 386 era and the DVD era overlapping that much…
My 486 had a single speed CDROM but it only had a 500mb and a 100mb hard drive, so still wasn't playing mp3s
The real weird one from that era was the 7 segment led MHz displays that were popular in the 386/486 era. It was weird because the the chips could not change speed in the first place. And I don't want to say every system was like this, but every one I ever saw was set by a set of static jumpers or a dip switch. When you upgraded your cpu you put the little sticker that came with it on the chassis and changed the jumpers, they served the same purpose.
I do remember using it to make older games play less bad, but, as you say, this rarely worked, I think precisely because the speed was never the original one (I don't remember the clock speed of my first PC, but the first one with a turbo button ran at 33 MHz which I'm sure is a lot more than twice the speed of the first one; seems closer to 8x from what a quick search implies).
I didn’t learn the real purpose until long after they were gone.
I knew what it was for and had some old games that ran too fast, but from what I remember, in most cases 16 MHz was still much too fast, so I didn't use the button much.
I think it was no problem to switch Turbo mode on and off in the middle of running software.