I asked a similar question some time ago and the response was deafening. I think it isn’t so much a failing of ERPNext , rather a an existential question of how it can be best done in a particular case. And there may be more than one correct answer. I think it might be best to sketch out what the ideal would be in practice , how you want it to look and feel, give some examples of how users and processes will react with the data - maybe you can distill something from that.
It may be that ERPNext tries to be too many things at once, however the Frappe framework might provide some opportunity to develop something on your own.