landscape lighting effects, looking for techniques to create warm white spotlights, path lights etc.

I definitely agree with @Conrad_C: trying to fake it in PS is going to take a lot of time and never look great. If you are actually shooting the images, too, I would suggest you get some cheap remote flashes that you can put around the house. Or even one and take multiple exposure and combine them in PS. You could also use good flashlight and light paint the areas and then combine the exposures. While not architecual photos, here are a few that I've done with a flashlight.

It won’t be easy to do this. Any quick and easy methods will look somewhat fake. Any convincing methods will require a lot of time and manual work per image. This probably requires advanced skills and time.

I like to relight images using gradients, and some examples are in the demo below. I created multiple radial gradients for lights along the front of the building and up the tree. It doesn’t look convincing enough for me, and I think it’s because of the direction of the light requiring changes to where light and shadow fall. Looking at your example images, the lights illuminate buildings and trees from below. That means the undersides of buildings and tree leaves must be lit, but the top sides should be in shadow. This cannot be done automatically, because Photoshop features don’t know about the real-world shapes of those objects and how they should catch light and create shadows.

I think my example has many flaws, and I wouldn’t use it for promotions. (The gradients are actually smoother than they look, but the Adobe forum software degrades GIF animations.)

If you wanted to do it this way, you would need to learn:

Creating and editing gradients

Creating and editing masks

Creating and editing layer style effects (I used this to try and give some dimensions to the tree leaves, but it looks awful)

Editing the BlendIf options for a layer (I used this to mask off the tree from the sky)

Using layer blending modes

Another major problem is that the sample attached images, such as 2288, don’t have a lot of dynamic range. The shadows are completely blocked (so you can’t reveal details in the trees), and the highlights are completely blown (so you can’t see details in the moon or the lit parts of the building). So for example, you want to light the undersides of tree leaves, but the leaves are in the dark with no shadow detail so the leaves can’t even be found.

If this was my job, this is how I would do it:

1. Take a raw photo of each site that has detail from deep shadows to bright highlights. If the camera sensor can’t cover that, I’ll bracket exposures and merge to HDR in Camera Raw or Lightroom Classic.

2. Add an adjustment layer that sets the light level and color temperature for the most brightly lit areas.

3. Paint in the adjustment layer mask to block out all the areas that are not lit, shaping the lit areas to fit how the light would spread out from each lamp. Adding gradients the mask might make this easier.

4. Add more masked adjustment layers to account for things like brighter undersides, and shadows cast by the lights.

I am not sure I fully understand. 

Please post examples – ideally of both the images you are working with and of images that illustrate the kind of effect you are trying to achieve. 

Entiendo que tienes un negocio y tienes prisa en obtener respuesta. Mientras la esperas, sugiero que explores Behance.net. He visto post-producciones que responden por su habilidad, aunque la temática es otra, a lo que buscas. Están ahí para recibir ofertas. Si encuentras algo como lo que buscas, aunque sea aplicado a otros fines, el contacto puede resultar rápido, supongo que pagando. Supongo que Youtube ya lo exploraste. También puede ayudarte Chatgpt, donde incluso puedes subir una foto y solicitarle para ella lo que aquí solicitas