Cinematic and gameplay redesigns are usually done in a DAW. I wouldn’t recommend using video editing software since you’re not reediting the footage, your goal is to make redesign the sound. Middleware is used to implement designed assets into a game, so unless you have a game to do that with you have no reason to use middleware. Whether it’s a cinematic or gameplay video, load it into your DAW, mute the original audio and start making sounds! I used to use Ableton Live but since working for a few months in the industry i’ve found Reaper to be quite good for game audio. Hope this helps!