What did the Buddha say about motivation? What did the Buddha say about wholesome types of motivation?

Is there a difference in the Pali language between "intention" (as in Right Intention) and "motivation"?

From what I understand Right Intention is renunciation, good-will and harmlessness. I can understand how good-will and maybe renunciation can be a sort of motivation, but harmlessness seems to be more passive and therefore maybe not a motivation in the same way

Basically what I'm looking for are the things that motivate us (as in "drives us") to do things, which are considered wholesome in Buddhism

(Maybe there is also a connection to Right Effort here)

Grateful for help with understanding this better!
Right effort(sammā-vāyāma) in terms of mindfulness is not a forceful , grit your teeth kind of effort. It's a moment by moment, continuous, good cyclical habit kind of effort.
Cetanā is Pali for
1- intention
2- volition
3- directionality of mind
4- attraction
5- urge
Intention(cetanā) can be defined as a mental factor that moves or urges the mind in a particular direction, toward a specific object or goal. Intention(cetanā) is the most significant mental factor involved in the creation of karma.
Sammā-vāyāma and cetanā are two different concepts. In practice, one concept(or the actual experience the concept points towards) might happen right after the other though. Then there is right intention (samma sankappa) that isn't really like sammā-vāyāma. Imho at least.
Samvega, the sense of shock and empty alienation that comes with realizing the futility and meaninglessness of living in the sleeping world, is what motivated the Buddha and others onto the wholesome eightfold path. Some are motivated by other things like faith(saddhā) in the  Buddha's teaching.
Right effort and right view are the two most important factors for an insight meditator to understand, it seems to me.
Right effort can be something like, effort to continue striving to remember to focus awareness on whatever experience arises in awareness and to strive in a broader sense to transcend all assumptions even the ones we don't yet see.
The Four Supreme Efforts
(cattārimāni sammappadhānāni)
1-Restraint Not to let an unwholesome thought arise which has not yet arisen(anuppādāya)
2-Abandonment Not to let an unwholesome thought continue which has already arisen.(pahānāya)
3-Cultivation To make a wholesome thought arise which has not yet arisen.(uppādāya)
4-Preservation To make a wholesome thought continue which has already arisen.(ṭhitiyā)
Effort can come easier with interest but then the path is to eventually develop a certain disinterest.