You probably won't find a whole lot of guitar instruction books without theory and scales in them. Your best bet is find a book of tabs or search the tabs out on the internet and develop your listening ability with the song on CD.
Unfortunately, there's quite a few innacurate tabs out there tho...especially on the net. Even some commercially available tabs are done wrong.
I was bored to death of scales and theory when I first started out too. Basically for about the first 5 years the only way I learned songs was to buy the album, go to the local store and copy down the chord charts (so I didn't have to buy the book), and then spending hours listening to the leads and trying to figure out how the guy originally played it.
It's actually an advantage to develop your ear that way because after awhile you can learn to figure out how leads are played by ear, just by the way the strings or chords sound. You can tell which chord it is and instinctively know which string is being used just by the timbre of the sound.