It sounds like you probably already have quite a bit more experience than me, so I suppose I can't really give advice. I can, however, say that I feel the same way! After not playing for about 10 years, and now coming back to it, I'm essentially going back to basics and re-learning pretty much from the ground up. Between trying to learn some basic theory, scales, modes, posture, rhythm, not to mention songs, yada, yada, yada... it all gets quite overwhelming. Unfortunately, there are only so many hours in the day. Like many folks here, work and other responsibilities make it difficult to dedicate the time that I'd like to the instrument.
Right now, I'm feeling kinda like a 16 year old learning to drive again.... white knuckles grasping on the steering wheel, only looking at the road just a few feet in front of the bumper. It's only been about 7-8 weeks since I've gotten back into playing. I figure that once the initial information overload subsides, and things begin to sink in a bit more, I'll be a little more relaxed.
I thought about purchasing Guitar Aerobics, but I figured there are already a number of things that I'm working on. I too have been doing a lot of scales, and was afraid of getting too bogged down in an entire book of exercises. The scales DO tend to get boring, but I've started doing a few scale sequences and intermingling the scale positions (descend one shape and accent the next shape up neck) to mix things up a bit. That's been a big help with the scales, but also with the muscle memory. There are a few other exercises out there (
the spider comes to mind) that I use when scales really get boring.
I've finally started to concentrate a bit more on some individual songs. I've really wanted to tackle a few fingerstyle songs (I know a lot of Dust in the Wind and Blackbird, but Never Going Back Again should be added to my list!), but I've sort of put that on the back burner right now cause I'd like to improve my flatpicking (my accuracy and consistency needs a lot of help!).
Hmmmm.... After all that, I suppose I can say that I have been intentionally limiting some of the things I'm taking on at the same time. I'm trying to be a more patient this time around. It'll be decades of learning, and while I DO want to progress as quickly as possible, I have to keep telling myself that I DON'T need to learn it all this week!