You can make logos in softwear like Photoshop and add effects and movement in software like After Effects or if it is simple in Adobe Premiere. Once you got a video you want to put at the start of the game before it enters you can find the location in Edit>Project Settings and then go to movies and add an element and wire it up to the MP4 location.
Hope this is what you meant.
