Best Software for Creating Jaw-Dropping Visual Effects in Videos?

Hey fellow creators!
I’m working on a project and I’m wondering what your preferred software or tools are for creating stunning visual effects in videos?
Any recommendations or tips would be greatly appreciated!
Thank You!

Given the complexity of doing this it should be more about what you are comfortable using more than anything but something like After Effects is going to be a good choice