I have actually built something like this.
I modeled a base (and 3D printed in ASA) that holds a Fibaro FGD-212 dimmer, and have that exact bulb fitting (but black) screwed into the base.
There’s a button on the front that is connected to S1 of the dimmer to be able to turn the light on from the base.
I did this YEARS ago so I would probably do it differently now, but maybe it gives you some inspiration.
https://www.imgdumper.nl/uploads9/655b46e5d90c1/655b46e5d4639-photo1700480702.jpeg
https://www.imgdumper.nl/uploads9/655b47068c316/655b47068711e-photo1700480702%281%29.jpeg
https://www.imgdumper.nl/uploads9/655b471175a8a/655b471170461-photo1700480702%282%29.jpeg
https://www.imgdumper.nl/uploads9/655b471c6bed6/655b471c67f73-photo1700480702%283%29.jpeg
It could still be used to turn the light off and on, but it’s an actual switch cutting power to the light and isn’t operated by something smart