I've looked at bulb cameras for awhile and steered clear of them since you loose the light. Seems to solve that problem if you leave the switch on.
Looks like you can install a SD card and avoid the recurring cloud extortion fees.
All my exterior light fixtures are enclosed, so not sure it will fit. Not to mention the IR LED will simply wash out the camera when if reflects off the light figure glass. If it is similar to the other Fusion line of cameras, you can turn off the IR LEDs and has RTSP streams.
My HOA would likely forbid them since they are not clear incandescent bulbs.