I taught myself years ago with just a book so it can certainly be done. Do you know anybody else who plays? I think motivation is the big factor with this sort of thing, you aren't going to be Jimmy Page or Hendrix (or whoever you want to sound like in a day). I am not anywhere near as good as I would like to be after 20 years. You need to practice regularly and stick at it when you sound rubbish and you have sore fingers. Barre chords will most likely be difficult at first, stick with it as they are very useful. Get in the habit of picking both up and down as soon as you can.
I found the Guitar Handbook by Ralph Denyer useful but I don't know whether it is still in print. I has information on set up and electronics as well as a load of scales. My copy walked off with a guy I leant it to years ago so I can't check exactly what is in there.
You might find the 10 minute guitar workout by David Mead useful too,
There is a lot of stuff online these days, youtube etc so you may well not need a book at all. I would try to stick to one book or course rather than trying to do several at once at least to start with.
Blues pentatonic scales are pretty useful to learn for rock as well as blues.
Try to practice every day if you can even if it is only for 10 or 20 minutes. It is better to practice one hour a day for 5 days than 5 hours on one day and nothing for the rest IMO.
I have been playing Rocksmith on the xbox and it is OK but I don't think it would be ideal as a learning tool. That said I found it useful as motivation to get myself playing again now I don't have time to be in a band, or even have a jam most of the time. I would consider getting a couple of lessons to get your basic technique right from the start. I still have a ton of bad habits and it is quite hard to train yourself out of them.