Just found a thread with others reporting the same dim lights in auto mode that I mentioned
LED interior bulbs dimly on when in 'auto' mode

It is a bit worrying but apparently won't drain the battery unless I leave it for a few months...
Still haven't decided whether to leave them in the auto or off position though. I do like the lights coming on automatically when I unlock the car...