I tried the test in Logic Pro, and Logic can split, join, reverse, all without creating any new files. It seems this varies per DAW.
> I don't know much about video but, video editing is simpler, you probably have a GPU to take a good chunk of the load off of the CPU and latency is less of an issue. How often do you do you have two dozen video tracks playing at once with each going through a dozen effects while trying to record a few more video tracks in real time all on your CPU?
I wouldn't characterize video in general this way (although NLEs maybe), e.g., a couple of dozen layers with effects in Adobe After Effects is common, and After Effects utilizes more CPU than GPU generally. After Effects can do all these operations without creating new files as well (although it has extremely aggressive caching both in RAM and on disk). (And real-time isn't as much a priority for video of course.)
I think this is partially an implementation detail, I think Ableton probably creates the extra files to help a bit with live performance since that's their focus. Whereas Logic Pro is a more generalist DAW. There are options to deliberately create new files, any time you want, in both (same with NLEs and After Effects).