How to achieve realistic terrain

hello everybody, i am working on a small terrain to be more specific its a cliff with no vegetation. i’m a beginner at this so how can i accomplish a realistic look. so far i have thought of unwrapping the UV and paint in photoshop but im only average with photoshop. also can a procedural approach give good results.

A good way to paint textures in photoshop is to use tiling textures that are set as patterns. Many cliffs have more than one type, or color of stone, so using multiple such textures can add interest and realism. You can also achieve layering type effects by experimenting with the x y z scale and map input, as well as colorband, with which you can assign a different colors based on the grayscale value of the texture. it might be kind of confusing if you haven’t used it before, so be sure to check the docs.
(edit) also, normals maps can be helpful. also known as bump mapping.

Use blenders texture painting. You need quite some power though.
A customer lately required a realistic landscape.
I use Bryce5 or A.N.T Landsacpe generator script to generate the basic landscape.
Then I split (only in thought to apply materials) the landscape into portions and apply generic checkerboard 4096*4096 UV maps, fitting the targeted resolution.
You got to decide it on the terms of the size of your landscape, the rendersize and the power of your machine.
After that, go to mayang or cgtextures and start to prepare your texture brushes… grass, rock and stuff. Once done, setup your brushes for texture paint and then you´r good to go.
Enter texture paint and simply paint your terrain, with all the blending, mixing and brushes you get awesome results.

hth