I'm looking for a more code focused way to edit my lyric music videos

I am an indie musician. I do all my own music production, video editing, social media curation, etc... The thing that I struggle with most, is making lyric videos for all of my songs. What I want to do is make some of of a template that takes the input of my lyrics, audio file, and a bunch of relevant short video clips, and uses that to make a lyric video. I've tried CapCut but I couldn't find any tempo sync settings in any of the templates I tried. After Effects and Premiere Pro both have lots of available templates, but I kept running into the same tempo problem that I did with CapCut.

Is there some kind of solution that can do what I want?

Or maybe a more modifiable video editing software that lets me run custom code? I know that the 3D modeling software Blender allows you to run python scripts, maybe there's a video editor that allows this?