Sounds like you need to set intermediate goals. When I started playing the guitar, I asked my teacher „Do you think I‘ll be able to play anything from Muse soon?“ He was like „Uhhm maybe, if you practice super hard? But let’s focus on getting this Smoke on the water to sound absolutely sick!“

For a long time, my only goal was to make the finger exercises sound good. Play them with a metronome and push the number higher and higher. Integrate little licks into the practice routine, keeping pace with the metronome. My guitar teacher was _extremely_ motivated and this was contagious.

Before I knew it, I could easily play most pop songs and many rock songs. I didn’t even notice when I became able to play Muse because my interests had shifted by then. I joined a band and stayed with them for 5 years…

(Addendum)

… until I quit because having two little kids doesn’t mix well with a highly motivated band on the side. I guess I also had kind of a music playing burnout because the band was kinda toxic.

Haven’t touched the guitar for two years now, but I‘ll probably pick it up soon again, and learn new songs. Maybe record a reinterpretation of some electronic music I dig. Or make electronic music with guitar elements, like the late Daft Punk or something.

I'd recommend getting a teacher or someone who can plan your drills that forces you to play songs at your level.

I'm no prodigy and could play stuff in a few months (heavy metal), maybe a year. But that's only because I played actual songs along with the drills.