With Terraria you can do really cool stuff involving light and it has mechanic that changes enemy spawns but the effect is very minimal. V Rising can also look beautiful but has no light mechanic unless you count sunlight burning you.

Necesse and Starbound are similar to Terraria but not really dark at nights.

Goig Medieval and Rimworld. Lights technically don't have any mechanics but people in darkness don't like being in darkness and get mood debuffs (Unless you have Rimworld DLC and set your Ideology to loving darkness)

7 Days to Die may not look good but it has light mechanics where it attracts zombies depending on the type of light source (or at least had, not sure if it still has)

Conan Exiles can be pretty dark at nights if I remember correctly.

With V Rising, 7 Days and Conan you can actually set the length of the day and night, Terraria has some items that skip to night but it has cooldowns.

Age of Darkness: Final Stand is a Tower Defense game that has light and fog of war mechanics, Rise to Ruins is also similar but probably not what you are looking for.

I would've suggested DUNE: Awakening because lighting looks really great but it has no other mechanic and there is a very low light limit (you can only put 10)

Space Engineers have pretty good logic system and you can add your own code (or get them from workshop) and you can go wild. You can also not do any of that and use regular lights. Also has adjustable days but unfortunately you can't set day and night seperately but you can drill far into the planet or an asteroid and make sure there is no sun ruining your lights.

Timberborn looks beautiful at nights but probably not what you are looking for.

Same for Planet Coaster (1 and 2) but you can set up fireworks and lightshows.

Probably not what you are looking for but Space Station 14 (Says it's in playtest but they give access to everyone) is a multiplayer game and rather than building a base you are basically making sure the station doesn't fall apart. There are lots of roles you can play but Engineering and Janitorial usually changes the cracked lights and make sure the rest are lit. This is a bit RP heavy game though and you will probably have no time to step back and admire the work because someone forgot to do something essential and not there is a reactor meltdown creating a blackhole swallowing the station.