Many WiFi bulbs are vendor locked with no local access (or local access only through the vendor's app). Others are not, including:
- Hubitat natively supports YeeLights.
- @djgutheinz has written a Hubitat integration for TP-Link products including their bulbs
- @rob has written an integration for LIFX bulbs
- @adamkempenich has written a Hubitat integration for Magic Home WiFi devices
There are integrations for bulbs that can be tasmotized, which require the bulbs to be modified.
P.S. Welcome to Hubitat!