Having the motion sensor trigger saving local recordings is an idea that have gotten a positive dev response.
https://github.com/themactep/thingino-firmware/discussions/289
I can't find any discussions about accessing recordings using ONVIF or the tinycam app and don't have any cams running personally.
I am planning on using thingino with frigate nvr and network storage later on so thanks for sharing your experience!