In KDE, YES!
Crap, I can't remember 100% how I did it but they support sound themes now.
But my OpenSUSE Tumbleweed system running KDE6 starts up with this startup sound, I think I pulled the MechWarrior Online startup sound off YouTube or something. :)
...Now if only I could make my car do this... ๐