Whenever people say this I ask about After Effects. I have yet to find a FOSS or cheaper substitute. Many people have suggestions for Premiere Pro replacements, but not After Effects.
His examples tend to be specific to VFX, but Blender is quite general-purpose as far as motion design goes with an NLE, support for the familiar “expressions” paradigm, and so on.
I mean, can you code procedural FX with Python in After Effects? You can in Blender. And it's free.
2.90 is shockingly good.
For really simple things you can also use Hitfilm Pro
There is also https://natrongithub.github.io/ but I haven't personally tried it