There is a book called Western US Pilots Guide which has lots of colourful photos of some of the more worthwhile airports to visit, including airport diagrams, area photos and a little bit of information on why you might want to go there. The journalism is not the highest quality but its good enough. I even agreed with some of their choices of which airports to include. I've seen something similar for the Bahamas and I'm sure there will be a Florida/Eastern US one out there.
Personally, I used a combination of the Rough Guide USA, sectionals and AFDs and the Best Western Hotels catalogue.