I went into Rocksmith because of this promise and for me it worked out well. Though it did not greatly improve my guitar playing skills beyond some of the basics, I do enjoy that I can interact in some way with the music that I like. It's like whistling along with your favourite song but with your hands, so the experience is much more engaging and it's feels more rewarding than guitar hero as the sound that I'm making sound a lot more like music than that clicking of buttons.
Nowadays they have a subscription service, I don't know what the quality of that is. But I mostly still play on the "2014 remastered" edition with a "real tone cable" on macOS, but I think they updated that and you can play with any "audio interface" device you like. There is also the customsforge library for unofficial songs, but quality varies.
Between Rocksmith and Youtube tutorials, playing along with my favourite songs is the most fun I can get out off playing guitar that my skill level and time investment allows. I'll never play in a band or make a decent sounding song, but enjoying and getting enveloped by music is good enough.