A large or small engine can do what is in the video. Maintain constant speed with good accleration? Yeah youre right you don't need the biggest engine for that. Is the large scale speed record still 97.96mph on a 27.2? Theres a reason he chose the 27.2 over a 30.5 or a 26. He matched his engine to its intended application.
If your being timed in a race, want the most effeciency, or want the best performance your best bet is to match the powerband to its inteneded application. Each engine build has a different powerband. Do you need high rpm, power down low/mid/top/lowmid/midtop, where do you want the most throttle response, top speed, pipe, gearing, etc.etc. If only one engine was all we needed for every stituation there wouldnt be any others. I tried to illustrate that in each of my examples 1,2,3. If I was in a race my life depended on I personally wouldnt use the same engine in all three examples.
This is the real world though, I only want to have fun. I want my car to accelerate fast, go 40+mph, be able to do some mild climbing, be able to floor it while turning and not skid out, and not break the drivetrain. Those are the real limiting factors to me. I don't need to know "between a 27.2, 28.9, 28.5, 26, which one is a few seconds quicker?" Those are my personal engine choices because they all meet my needs and get my job done.
Sometimes you do need a big bore: would you rather have an which would perform better a super built 23 or a super built 28.5 in a Ramp MT?