Some of the weirdest music I have in my entire library comes from a Sacramento band called Warp 11. Their repertoire consists solely of songs written about and inspired by Star Trek. And surprising amount of their stuff is definitely NSFW.
For example, their debut album is called Suck my Spock and a 2005 record entitled Boldy Go Down on Me. There’s a song about Mr. Sulu that is rather raunchy. They write about the Borg Queen, Dr. McCoy, Scotty, transporters, phasers, aliens and anything else you can think of across all the ST series. This is from a record entitled Red Alert.