I’m a beginner electric guitar player and what motivated and helped me is learning songs I want to play. The first was Zombie by The Cranberries. The satisfaction and sense of accomplishment when you pin down the chords and strumming is amazing.
Second was Tomorrow by Silverchair (excluding the Daniel Johns solo which is way beyond my skills). Rant: Silverchair is super underrated of the grunge area bands, Daniel Johns is a fantastic musician.