They don't work for everybody though; I have ADHD and Ritalin/Focalin help just a little (and only if I take them to the point where I feel like pressed-meat in the mornings), while Adderall gives me hallucinations.
No, the drugs don't make doing chores fun or any of that.
For those with ADHD they turn on the prefrontal cortex which reduces or removes the feeling of utter torture and pain from doing chores.
It's sort of like taking a drug that takes away the fear and almost physical inability to to touch a hot stove most people have. Normally that'd be bad. Except here the hot stove is actually harmless and useful to touch.
there are many drugs that can do that but they have massive side effects ;)
Benzodiazepines, opioids, stimulants, opioid-like substances like carisoprodol (there is a reason why people call it Soma). these are the first that come to my mind. contrary to popular belief, downers often give you euphoria.