Welcome to the forums !
The usual candidates come to mind: Hikvision, Dahua, Reolink or one of their OEMs. Almost all of them have ONVIF or at least RTSP support (that makes them cloud independent) and are powered through PoE. They’re all highly configurable. They also integrate into HA, but keep in mind that native HA support for cameras is not that great. Here’s more info.
For my indoor cams (which I physically remove unless I’m on vacation), I use the Hikvision 4MP cubecams. They have a clip on base, so you can leave the base screwed to your ceiling and clip the camera on only when needed. They’re about 100€ here from an official distributor. They have both PoE LAN and wifi support. I’m using a dedicated hardware NVR, but you can just as well use a software solution like Blue Iris or Frigate.
Only caveat with all IP cameras regardless of manufacturer (and especially Chinese ones), do not give them internet access. Keep them isolated on their own LAN or VLAN in their own subnet.