I wrote, recorded in my studio, played, and Claudia-Marie sang the music we use at the intro and outro of our vids and also in the trailers we make. Of course we don't use music during the actual vid. But in my opinion it's definitely needed for the sex parts of the trailers.
Back in the mid 1990's I did the music for Centerstage Productions Vids...but the money was shit and the time involved to do quality original music made me stop doing it after a few months. I thought that if I did it, it would get some attention for the music, my skills, etc. and lead to something more.
It didn't. It just used up a lot of my time.

It'd be a lot easier these days with the ability to just grab some beats and toss some sequenced stuff over top of it. I have a Yamaha QY100 sequencer that I can program in and have any style song in any key at any tempo in about 10 seconds. Mixed and ready to go.
But I'm too old school to do that. With the song "Get With Me" that we use, it's all real players recorded the right way. Took about 4 months of tweaking for me to mix it the way I wanted to hear it.
But using the Yamaha QY100 I could churn out generic porn music that would kick ass all day long. So maybe you can do something like that where it's not time intensive and could be feasible.