Stanley Yates' Mel Bay’s Modern Classical Guitar Method is the most chord-oriented of classical methods, and in that sense is good for tying things together.
For chord-focused strum-style books I like the "Guitar Chord and Accompaniment" series by Yoichi Arakawa, which are strangely out-of-print even though they are recent books, I got them from the library system.
For traditional folk-song approach, there are tons of options, but I'll mention some of my favorites like "How to Play the Guitar", "Beginning the Folk Guitar" and "Folksinger's Guitar Guide" (all out of print) all by Jerry Silverman.
The common traditional methods, such as the Alfred Basic Guitar and the Dick Bennett books I already mentioned. The 21st century Guitar Method books are ok. There's also Mel Bay's "Mastering The Guitar" series, which is multi-style and multi-approach.
I already mentioned Richard Corr's "Guitar Academy" books which are promising multi-style books.
"Acoustic Guitar Styles" by Larry Sandberg teaches traditional fingerpicking and chords and such in a very special non-rote way that I highly recommend. The only issue is that it is not very modern.
For a more modern approach there's the "Complete Guitar Player" by Russ Shipton or the Rock & Pop version by Rikky Rooksby. Both of those use pop recordings as their focus but have a non-standard crappy notation system.
Although I think it is much too challenging to fit the title, perhaps in your case Frederick Noad's "Complete Idiot's Guide To Guitar" might be good. That teaches many styles, not just classical.
The Hal Leonard Guitar Method's "Acoustic Guitar" book by Chad Johnson is great for really being modern, using popular recordings as examples, but it isn't simple beginner stuff, it's more intermediate level.
Overall, for folk/pop chord approach, there are tons of books that basically teach the stuff pretty well for the traditional ideas but basically all of them fail to teach it the way it really should be taught. I use them all and then I add all sorts of extra discussion and understanding. I haven't seen any book that's ideal yet.
I'd recommend "Beginning Guitarist's Handbook" by Jeffrey Pepper Rodgers for acoustic style general ideas and attitudes that should be understood along with whatever method book.
And I'll once again mention The Listening Book by W.A. Mathieu...