There are plenty of devices that support a lot of integrations.

However, those companies don’t make the kind of perpetual revenue that bring in capital, and the companies that make the devices that don’t make you pay for their service end up not lasting as long as those that do.

Sadly, it seems that the prudent business decision is to lock your customers into your ecosystem.

Not exactly home gamer stuff, but there are devices like the Axis cameras which can push to a configured mqtt.

Generally ONVIF is the protocol one should be looking for in a camera, it indicates that the edge device can play ball with a central server (Frigate, Blue Iris, etc). Profile M specifies the metadata into external mqtt:

https://www.onvif.org/profiles/profile-m/