What you seem to be looking for is a matte painter, and that is what I excel in the most.
I have worked on several projects involved as a matte painter, designing sky plates, day for night shots, and even compositing of the matte shots in to real world footage.
you can refer to my portfolio for examples, but my website showcases more of my work.
Best Regards