You can actually do this now with the active and not active sequences you can use date rating ect.. the only problem is the Trivia.. your default Trivia folder is the only one you can have in a sequence so having separate Trivia slides wouldn't work currently but separate Bumpers for holidays ect does ..
I believe the older Cinema Experience add-on used to do this using .nfo files. It was suppose to added to CinemaVision but it never came through. Would love to see this back in this add-on. As of now, I put trailers in different folders based on genre and link the folder to the sequence I use. This would make things a lot easier for me.
I would keep my home automation separate from Kodi, always, but the functionality to be able to trigger automation in PSE after an event is nice. I use Home Assistant for my home automation, so something to notify it either before or after a movie would be nice.
So I'm not sure if this might help or not. There is a Kodi add-on called Stinger Scene Notification. This add-on notifies you of stinger scenes in the current movie, popping up a notification when the credits roll. It uses tags to identify movies that have a stinger scene. The important part of this is that somehow it knows when the credits are starting to roll. Perhaps this can be modified/incorporated into PSE to handle turning on the lights and perhaps other functions as well.