Thanks for sharing! It is evident that you put a lot of thought into your naming scheme. Yes, it looks a bit overwhelming at first, but you made some points I not even have thought about. Some details are less relevant for me (because I don't have rolls of film or slides to manage, for example), but the reasoning behind is easily adaptable to other questions.
I would also be interested to hear how you will manage to automate your workflow as much as possible. There must be a good part of automation, I suppose, because performing the naming manually would be very labour intensive.