Did a parasitic draw test. I could hear a light clicking noise coming from somewhere near the SJB. Started pulling out fuses one by one and the clicking noise stopped on a couple of them but only one caused a change in the multi-meter reading. Weirdly it corresponded to the right low beam which i am sure shouldn't have been on at the time. The battery was too weak so I boosted the car and tried starting it. And it started!!
I hesitantly plugged in the right headlight fuse but the car kept running. Disconnected the booster cables and let engine run for another 10 minutes, no issues. I then turned the car off completely and pulled the key out and locked the doors. Then unlocked and started again and everything including the right low beams worked!! I then put in a fuse for the original puddle lights/backlighting issue and, guess what, they started working again.
Not sure if I'll have issues later on, but for now I'm happy the car can at least start and seems to be problem free. These SJBs can certainly be unpredictable and may have logic to disable some circuits if they suspect an issue with them. So Akirby, you may have been right, all it needed was sometime in the dark to reset. It might also be a battery problem. It is 3 years old but other incidents/observations tell me it may need replacement. Batteries don't seem to last long on these cars up here.
Happy Canada Day /4th of July!!