I'm confused what you are not finding. There are so so many smart switches on the market, they dim, and then the dim all the way to off.
They don't have a relay, they just (more or less) dim until the light is off.
Home automation is the residential extension of building automation.
It is automation of the home, housework or household activity.
Home automation may include centralized control of lighting, HVAC (heating, ventilation and air conditioning), appliances, security locks of gates and doors and other systems, to provide improved convenience, comfort, energy efficiency and security.
Warning: Working with electricity can result in injury, property damage, or even death if it is not done properly. Please keep this in mind while assisting others. If you are not sure about what you are doing, hire a licensed professional.
I'm confused what you are not finding. There are so so many smart switches on the market, they dim, and then the dim all the way to off.
They don't have a relay, they just (more or less) dim until the light is off.
Zooz, inovelli, leviton, ge, all the brands make dimming smart switches.
I think what you want is all those recessed lights going to a single pole switch on a wall. Then install you a nice dimmer switch of your preference. I like inovellis.
Maybe it's different in the US but here in Europe I have trouble finding a mains-powered rotary knob, they all come with an internal dimmer, like this one, which I believe is what you want?
Shelly makes one that's currently half off for Black Friday (just got an email ad for it)
You're not going to find a relay dimmer as a relay is a on/off only device what you're wanting is a dimmer that can go to zero so any of the devices that work with the type of bulb you have right the LED or whatever it says it's a dimmer we'll have the ability to go completely to zero and turn the light off