This is a similar approach to when i used it long ago when it was xmbc. My media is well organised on my file system so I'd point xmbc at a smb share and navigate from there.
What made Kodi/xbmc great was the interface worked better on a couch using a game controller to navigate versus a traditional desktop where i'd be forced to use a keyboard+mouse.
Kodi is very flexible and you can make the menus behave just like you want. Setting it up can take a bit of fooling around to figure out but it's quite straight-forward once it clicks.
I googled a bit and yes, there does seem to be a way to configure a top-level file browser with super favourites add-on. For sorting, I see nothing appropriate, though.
So, yes, Kodi is flexible, but too tricky for leisure use.