The reason none of your haptic controllers played tunes is because the programmers never got to have fun with it, not from a lack of ability.

Go look at 3D printers, most of them use their motors to make little beeps and jingles as feedback to the user. I even have custom gcode that gets added to every print so a tune is played when the print is done. That's actually useful because I don't need to wonder whether it's done and check on it like a pot that's about to boil

Wiimote played sounds, and from what I saw online, that shitty little speaker gave a lot of memories to kids (especially the Smash Bros Brawl sounds)

Older controllers probably didn't have haptics that could be controlled to playback sound files. Once you have that though, it's relatively free to add. It's not a feature the controller is sold on, because it doesn't really matter, but it is a cool bonus to add for free, and let's the devs have a little fun.

My DualSense controller has a literal speaker in it, and lots of PS5 games use it. Are you mad at that too?