This isn't how the vast majority of operations work in the two DAWs I'm the most familiar with (Ableton Live and Logic Pro) work, most actions are non-destructive and don't result in extra files on your computer (e.g., the original file is referenced, and edits are applied on top of that without modifying the underlying audio file [a la Lightroom for photos]). There are certainly situations where new audio files are written, but it's usually crystal clear when you're doing so.
For the record, I agree with your overall point. DAWs abstract away a lot of the details of the underlying audio files, and there's definitely space for tools like Audacity that are designed to edit audio files staying closer to their export formats. So just clarifying that I wouldn't phrase the downside of DAWs (or at least not all DAWs) around creating a bunch of extra files (although I'd be curious to hear which DAWs actually do work that way [i.e., create new audio files based on edits], just for my own learning).