Actually I'm not even sure where to start.

I play (mostly acoustic) guitar for about 4 year now and at the beginning (lets say 2 first years of playing) I was really inspired but now I kinda lost it.
I don't know when it all started. Maybe when I started guitar lessons (after about 2 years of playing) so that i could progress even faster. 

First of my teachers was teaching me how to play fingerstyle pieces note for note but that was totally not what I was trying to pursue even though I appreciated how my guitar control improved. 

I started lessons with second teacher with aim of learning some music theory. I liked it at first but then felt overwhelmed with amount of things to learn (scales, modes, intervals, progressions) and I felt like we were just jumping around from topic to topic and after 1.5 year I must admit I learnt almost nothing. Maybe because my teacher didn't really check If i progress, maybe I couldn't find application for this knowledge or maybe we tried with wrong repertoire (jazz and than switched to blues on my request)

At this point I feel like there is no way for me to progress because If I lost 2 years of playing then there is no way for me to learn anything new. When I pick up a guitar I just noodle around with the same old things I played even before I started my lessons! after 30min of playing I feel frustrated with that and just put it down.

I don't want to give up and that's why I write it here but I don't know what to do... 
Should I give another shot with a different guitar teacher? I also thought that maybe changing gear would help a little but I don't believe it since I'm completely not a gear person. Maybe switch to piano for a while would help?

What I want to be able to do with my guitar is to play kinda like intro in this cover: 

 and I want to be able to pick songs from radio by ear and arrange them my way taking into account that I sing a bit. I just want to have fun again.