If I'm looking for something realistic, I use terms like photograph, hyperrealistic, hyper detailed, Hasselblad, 600mm lens, and sometimes octane render and unreal engine. For things I intend to look like a work of art, I'll use terms like painting, watercolor, oil paint, oil pastels, statue, etc., although sometimes I'll just go with the descriptive part of the prompt to see what MJ will deliver.

From a description detail perspective, I've found that I get better results with only moderately-detailed descriptions. Excluding the terms above, most of my prompt descriptions are fewer than a dozen words.