Take the time before you start and think about the modelling, it will help a lot at the end. I don’t do and have done the job several times now
I finally derive a model in textual form (per location / room) and insert it with “Add Items from Textual Definition”. I like doing it in this way because you can easily modify (not delete, but modify) a bunch of items at once later (and I do it several times now). Also thinking on a restart from scratch at some time in future will be much easier then (hopefully).
Looking into your tips my first idea is to derive (later) some useful adaptations. Searching for things in the jsondb is a hard job e.g. if you search something in a rule (because the format is not very helpful). So a search in the rules via UI would help