making terrains that look good...

So I've been playing with terrains for awhile now. I've been using some 3rd party add-ins that make the workflow really easy. While I can technically make terrains, they don't have that wow factor.
I know it's me and not the tools. Can I get some information about what stuff goes into making a "good" terrain? References, docs, anything would be helpful.

Thanks!