Inspired this by great photo of Bas Van Der Poel from Chateau Henri, a lot of overpainting and some post processing has been done clearly. Blender 4.1 / Cycles.
I was unfamiliar with Bas van der Poel… here’s part of the website: