I got a response from Starling! The gist is that it should work just like any other HomeKit camera, which is to say, anything that works for cameras over HomeKit should work for Nest Cams through Starling Home Hub. However, they actually recommend someone creating an official integration using their API, as it could be better-integrated—and they would contribute some resources towards helping out (just not committing to fully leading the effort).