kodi is best as a front-end for an already curated library. ive used it extensively since the xbmc days...
i use mediaelch to scrape, generate metadata files and rename files and folders into a standard way. it [can] generate things in a kodi-compatible format. kodi is set to just pull in that data. i concurrently use emby (jellyfin) to access that same metadata.
your problem is conflating the curation of your library with the applications that will use it.
kodi does need a full computer to run. thats where emby comes in. its for viewing the same shit on any other device