The magazine the Auto Club sends me does that. Called "Home & Away" it is something produced by the Oklahoma Auto Club wrapped around something that comes from AAA National.
I've collected them for about 20 years and somewhere in that collection much of the country, and many places overseas, will have been covered. Going through them gives me travel ideas.
The magazines "Trailer Life" and "Motorhome" usually have two or more destination articles per issue, and the approach is about visiting in a RV.
But considering the number of issues one must collect to have a large selection of destinations, I find I do better with books. There are several approaches: regional travel guides, collections of things alike (e.g. national parks, manufacturers, auto museums, great places to eat), scenic highways guides, and road trip guides.
Examples in my collection:
RV Vacations for Dummies
Road Trip USA
NGS Scenic Highways and Byways
Falcon's Scenic Driving Texas
Eccentric America
Watch It Made in the USA
Roadside History of Oklahoma
Adventure Guide to Oklahoma
Road Food
NGS Complete National Parks
Route 66 Lost and Found
See the USA the Easy Way
The Lincoln Highway
Exploring America by RV
Great RV Trips
Discovery Guide to the American Southwest
500 Places To See Before They Disappear
Lonely Planet Guide to Florida
501 Must See Destinations
Adventure Guide to the Alaska Highway
Sierra Club Guides to the National Parks (regional editions)
Scenic Driving Alaska and the Yukon
Tony Hillerman's Navajoland
The Colorado Plateau
Native Roads
Essential Guide to Black Canyon of the Gunnison
NGS Drives of a Lifetime
Weird Texas
The Most Scenic Drives in America
That's just what is stacked up by my desk right now, not including any for specific foreign destinations. Some of these are actual travel guides, some coffee table books. My children and sisters have filled my shelves with these as gifts, since I retired to travel 10 years ago.
But you don't need to buy the books, the travel and geography sections of a decent-sized public library will have a pretty good collection.
When you have an idea where you want to go, you can find travel information for just about anywhere on the World Wide Web, from national, state and local governments, chambers of commerce, peoples' travel blogs. Way too much information, not particularly well organized collectively, which is why I prefer books that have had the touch of a good editor applied to the work of a competent author.
P.S. Should you choose to build a good travel and road trip collection, and friends learn about it, you'll be called upon to "help me plan a trip to ..." but it usually gets me a good dinner and a few hour's company.