Here is a single flat clipped terrain turned on its side, you could do a little more rounding and add a more suitable material. Nothing spectacular, but you can see how a terrain can create an overhang, by painting the surface and then clipping the terrain from the bottom up. You could create special smoothing or blending filters, you could do a lot more.
jankeen.com