Yes, I would not apply distortion too liberally until you have spent some time studying and understanding the affects (slight pun intended). But in small to medium amounts, it can do cool things that don't involve the traditional "distorted" sounds. One use is for surgical audio repair, believe it or not. Adding small amounts of analog or analog-modeled distortion can smooth out digital distortion or slight clipping on tracks that cannot be addressed in other ways (like editing, for instance). Adding slight amounts until you can actually hear it, then backing off, can also beef up some tracks. But like compression, EQ, reverb, limiting, and other effects and signal processing, "easy does it" and "less is more" are the operative phrases. And when working "in the box," "undo" can be a great friend.
GJ