I think the main issue with SharePoint Lists and for that matter Libraries (and it worsening immensely now that the new Create List feature rollout and it gets easier to create lists) is the complete absence of viable automated methods for creating, updating and deleting list and library items - Interactively and in bulk (scheduled,Incremental or once and as part of automation processes)
If you want to do anything beyond the manual primitive "Quick Edit" (where you, by the way, lose all audit information like ModifiedBy, LatestVersion, etc.) you can either start coding heavily or use Flow.
The latter is almost useless because of lack of just about everything to with audit override, criteria, useful logging, performance, interactive previewing, interfaces to external data & other lists on other SP platforms and tennants. (I know the data gateway works for a little bit of that - believe me I have tried!)
Yes, you can do bits and small pieces with flow but it's like driving an old car from the 1950 ties .. and nowhere near the daily requirements in real-world production environments. AND what about SP on perm...!!!
And again - please don't give that "bull..t" about how great flow is. It is simply evidence that, that someone claiming anything in that direction simply the doesn't have a clue or has never tried in real-world heavy production scenarios.
SO --- We started coding the tool/utility that MS should have done from the very beginning of Lists & Libraries. And we plan to make it PUBLIC!
// Steen .... (the otherwise happy and gentle person) 🙂