Hello DanteAbe,
The best way to achieve this is with some Blueprint scripting and some time using the Matinee / cinematics system.
you will have to setup a blueprint telling the game to play the sequence on start or play once in the game, Then you will have to set up your animations and key frames. The two links I provided should help you flow in the right direction
Matinee system also has some Effects built in and you can make your own as well. I hope this helps!