Not only will the new Steam Controller scream at you but it can play tunes as well
(www.gamingonlinux.com)
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