Reolink cameras would be a great fit for your requirements. They support local SD card storage, have good apps, and offer models that work well indoors.
If you want to record the entire event, look for cameras with a pre-recording feature. Reolink has models like the Atlas PT Ultra that can capture everything. However, recording through glass can be tricky because IR LEDs will reflect off the window and create glare. You might need to use external lighting at night instead of relying on the camera’s IR.