Instead of a light bulb camera or lamp socket what about a porch light with integrated camera? Mounting and AC are already there. That would be a cleaner and nicer looking install. A competitor for this would be the Kuna smart security light.
[Mod Note]: Your request was moved to this topic for consistency in grouping similar requests. Please remember to scroll up to the top and click the VOTE button.