Esphome or ZigBee bulbs are the way to go, avoid tuya for WiFi bulbs
https://www.athom.tech/esphome
ZigBee bulbs I have gotten from aliexpress, they are usually pretty good, but you'll need a ZigBee antenna or bridge.
Tuya require a cloud connection, so best to avoid.
Unifi is local, with optional cloud. Very pricy though.