Phenylpiracetam works great for me, when it works anyways. It's kind of hit or miss, and definitely rather expensive. Seems like it's most effective when only used on occasion. A few times I noted a kind of uncomfortable stimulation which seemed to be smoothed out after taking some aniracetam with it. Certainly increased focus and motivation when it actually works. Odd one for sure...even when there was not much noticeable effect, it still seemed to cause a bit of insomnia. Usually anymore I take it on early mornings after long evenings (not much sleep) and it seems to make me more alert/awake throughout the day.
Noopept can help with motivation to an extent, but seems (at least for me) to be more effective in every way after taking it for a while. Occasional dosing with noopept seems to put me on edge a bit (easily irritated), but this seems to smooth out and go away after a few days to a week of taking it daily (unless dosing above 50mg or so).
Unfortunately, nothing really works very well for motivation on the long term if it cannot be found within oneself. Sincere interest in what you are doing can be rather motivational, but that may not always be in the cards on any given moment. Often what we have to do and what we want to do are very different from each other, but it's a matter of perspective...