Wow, great timing. I was just suggested Yousician by @AllysonR
I haven't tried it yet but what looks good is, like you say, it makes you more well-rounded. It also seems to help you with theory as you go along.
You're spot on, @klaasvakie, some of this definitely applies to Rocksmith. One of my biggest pet-peeves with RS was the same as yours — it does nothing for your memory.
At one point, I was playing for an hour every day. But if I picked up the guitar without those notes flying past my face? I wouldn't have a clue what to do.
To be fair, RS has a "master" mode where less and less notes fly past you as you progress in a song. But until the recent guitar duel, I didn't really feel compelled to use that.
In a way, I feel like these tools are AWESOME as long as you also practice without them. For me, with the recent challenge, knowing I had to record myself really motivated me to learn the parts. To the point now where I "know" both songs, even with Rocksmith closed.
So, yes, you definitely need focused practise outside of these games, IMO. Otherwise the skills you learn don't translate well to the real world.