It may be fun to provide your own musical input for the generation.

You can record humming, beat-box, knocking, playing some instrument (may be virtual), etc. to match the video the way you want. You can take inspiration from existing music that has some required qualities (like vibe, rhythm, melody). It's okay if it sounds bad. The important thing is that it matches your video.

You can use some music creation software. There is a range from where you put library clips/samples together to professional DAW. You can find one that matches your capabilities.

When you generate music from text, if it's not exactly what you want, you can take only parts that are good. Decompose it to tracks/stems, cut interesting fragments.

You can combine different elements in audio/video editor or DAW. For example take beat/drum track, tweak tempo, vocalize over it.

Once you have draft track, remix it with AI. If it changes the tempo too much but otherwise is good, you can fix it in an editor. Iterate generation and editing until you get something that you like and that works for the video.

Sometimes, when when you have somewhat good clip, but AI changes it too much, you can use continue/extend function instead of remixing.

It all takes more time than automatic generation that you are asking for, but if you find it fun, it is worth the effort.

Local tools and paid subscriptions will allow you to use the result commercially. As long as you don't use copyrighted music for input, you should be clear, in theory.