garnerb350, what he's describing is exactly the sort of thing I used to do with some of my model rockets. It's possible to achieve the effect he wants, but he'll need to practice a bit.
Hold the can about two to three times the distance and/or move the can quickly and you'll get the "mist" look.
Hold the can little further away and start/stop the spray while you're over the work (precisely the sort of thing spray painters tell you not to do) and you'll get larger "dots" while the smaller paint particles will dry before hitting the work. This requires a quick wipe down to remove the dry bits.
Some cans allows you to depress the nozzle only part way causing the paint to sputter. Some brands have some sort of internal mechanism that minimizes this problem. Try it with your brand and see if it works.
+1 to bfauska's comment about RC cars. Some of the inverse paint jobs these guys do, I could only ever dream of.
If you invest a little bit of money in something even as simple as those "disposable" spray guns used for models, you'll get effects leaps and bounds beyond what is possible by mixing your own paints, thinners and adjusting the nozzle and air pressure. Probably more investment than you really want though.