Ha, I've been doing this manually for years. I found smart lights that could get as low as 1850k and then put them in key areas in the house. After the kids go to bed, I try to limit all lighting to 1850K (as well as using that color temp on all screens that I use at night).
Of course I'm just one person so it's all anecdotal, but it definitely has helped my sleep in a noticeable way since I did it.
Cutting total light down a lot helps, too. The 60-75 watt (incandescent or equivalent) standard for lights—often with several such bulbs active per room, even—is way brighter than needed. Dropping room light to only enough to navigate the room safely, and using slightly-brighter (but still nowhere near 60 watt) lamps, either hand-portable or in particular locations, makes a huge difference, and you can still do almost anything in that kind of lighting.
Once you get used to much lower lighting at night, ordinary whole-room lighting seems insane. Why try to make it as bright as day at night? You can read, play board and card games, play music, even draw or something like that, with a small faction as much light as the typical house puts out when you flip the light switch in a room. And it has big effects on sleepiness (if you don't ruin it by staring at a hyper-stimulating glowing rectangle—color temp may help a little, but Internet-connected screens are sleep poison)
Of course I'm just one person so it's all anecdotal, but it definitely has helped my sleep in a noticeable way since I did it.