I’m also still dabbling around to get to know what exists out there and getting the hang of it, so just offering my 2 cents:
Does the video have audible beat indicators? If yes, using Audacity to filter them and then FunscriptGenerator (see this thread on Milovana) to generate a first draft of a funscript to then edit in OFS is something I’ve done. It’s not perfect, but I want to edit the script anyways, so usually errors are caught.
Generally for beats to actually match up to a song, the BPM has to be very precise. I’m talking 10+ digits for a 5 minute song. I then proceed to use alot of ‘Equalize’ and ‘Move to current position’ in the ‘Tempo’ view. Something for which I’m thinking of writing a lua-script at some point, since I want to learn how those work anyways. Talking about lua scripts/extensions: Kingleon9’s script collection has some neat features like ‘Multiply’ and ‘Equalize’ that help speed things up.
Concerning the precision (altering framerate comment): One might question whether this precision is necessary, since it usually can’t be felt. But I for one a) can’t stand things getting out of sync and b) further process the beats through sloping and other processes which turn out pretty erratic, if the beats aren’t aligned properly. Since I use the ‘Tempo’ view in OFS and align all beats to it, they are naturally precisely aligned to the music.