I don't have a lot of experience with methylphenidate, but I definitely feel that stimulants (therapeutic doses) can give you a boost in positive motivation during a time where one typically can feel pretty flat and unmotivated. I've always found amps/stims to be very helpful with getting through days of work that just tend to drag on especially if your brain is trying to reach homeostasis after a period of opiate abuse.
In my experience, as long as the dose is kept at a reasonable level and you don't go overboard trying to chase stimulant euphoria, they can be helpful during this situation.