With regards to your screenshots, given that the flowcharts are unreadable, you might want to just get rid of it and expand the function metric field.
I agree though, that models aren’t good for everything. They are great for general use, but there are times, especially when producing complicated reports, that it far easier and faster to use your own queries.
For instance, for my back ends, I wrote a table maintainer that builds a query on the fly so you can specify what fields and tables to use on the fly. Implementing it with models would be a nightmare. With queries it is a breeze. I still use models to save edits, so I get the best of both worlds.