The fact that mu opioid receptors cause downstream dopamine release when they're stimulated is what causes the drug to be enjoyable and thus reinforcing (activating/creating motivational circuits in your brain for the acquisition and consumption of the drug). The stimulation of the mu receptor has many other effects, including the mellow dreamy buzz you're talking about, partly by removing the inhibitions of neurons which secrete GABA (which broadly inhibits activity in the brain).
Now drugs like ritalin, on the other hand, are not strictly dopamine agonists. Ritalin in particular is a dopamine and norepinephrine reuptake inhibitor, and it will cause chemical signals emitted by dopamine or norepinephrine-secreting cells to be stronger, by forcing those chemicals to stay in contact with the receiving cells for a brief moment longer. But when you're talking about an organ as complex as the brain you have to be careful when making simplifications, like comparing the indirect dopamine release of opioids and the dopamine signal enhancement of stimulants. Opiods cause the release of dopamine in the reward center of the brain (nucleus accumbens and its projections), but stimulants nonselectively enhance the signal in whichever parts of the brain they infiltrate.
The brainstem, for example, is very important for wakefulness - there is something called the reticular activating system which is directly tied to the wakeful state. If it's destroyed you go into a permanent coma. Stimulants enhance the signalling of the brainstem and other related areas of the brain causing their stereotypical increase in wakefulness. That's just one example though; they affect many other systems including systems important for the regulation of impulses and attention and perseverance.
Very high, prolonged doses of amphetamines will cause dogs to display endless hunting behaviors, as if they're stealthily chasing prey which doesn't exist. The systems in place to allow the dog to feel satisfaction or a sense of completion are disrupted, preventing it from sensing that it's putting too much effort into something that's providing no benefit. The same effect is seen in humans, where they'll pick at hair follicles or minor imperfections in their skin, needing to feel that sense of having removed a problem but never receiving the signal of satisfaction or completion. Alternatively they'll pick at carpet fibers or rant about topics over and over.
It's hard to separate all of the systems in the brain and the chemicals they use to communicate into distinct compartments with clear-cut cause and effect relationships, because there are so many feedback mechanisms in place and projections to and from many other places. It's important to think about not only the chemicals and receptors involved in a drug's effects, but also to consider its distribution in different parts of the brain, and the big picture view of its influence on different neural circuits (systems across the brain connected by neuronal projections).