This is very expensive compared to an automated online system like google has.
But more importantly the local papers don't have the traffic necessary in order to make this a success. And people aren't doing searches on their local newspaper website for "plumber topeka kansas" they are doing it on google.
The local newspaper site doesn't have to be the only place where ads are shown, just like google.com isn't the only place where google ads are shown. Google has a large network, and newspapers could have a similar network. They had a great position 10 years ago, but I think it's still tenable now for some news organizations in many markets to be an information hub for that region, and some of that would/should involve becoming an information network, which includes an ad network.
Sites all over SE Michigan should have the option of running ads from an ad network managed by the Detroit Free Press, for example.
And while I did state that "feet on the street" are very expensive one thing that small business people definitely need is hand holding with respect to placing advertising. And I agree with what you are saying about assembling the network of sites.
The idea then would be to assembling a group of sites where the ads could run (similar to what google has done) and have the local sales force which knows the market offering the ad inventory.
Hard to believe this isn't being done already.
But... it's not that hard to believe it's not being done. This requires foresight and effort and some hard work that's outside the core competency of most media outlets. It requires a shift/pivot that most didn't see coming. Everyone wants the easy way out - just let google handle ours ads, and we get a check every month! Then one day you realize google controls a significant portion of your revenue, controls the relationships with the companies advertising on your site, and doesn't feel it needs you around anymore. Rude awakenings to be sure.
Additionally, most tech savvy people migrated to SV or NYC, leaving much of the rest of the country with less forward-thinking/visionary/tech-hungry people to drive this sort of thing. And if other papers aren't doing it, why should we? We might make a mistake!
There is a business model here to be developed, but it's also not one which is going to be a multibillion $ homerun overnight.
At the same time this sort of idea is being ignored by major papers/newsoutlets, larger companies like AOL were/are buzzing about "hyperlocal" and trying to get volunteers to write about local soccer games. Why? To have the content to drive hyper-local ads. At least, that was my understanding. But who's going to sell those ads? It should be newspapers, but they should be controlling local new media networks, instead of rolling over and playing dead (quite convincingly, imo).
That said, I don't really want it to be MS. I thought their ad/mgt tech was awful, but... with a bit of polish, removing references to MS, and some sales, they could make a dent in this market.
Our motivation to help was straightforward: we'd been partnering with hundreds of newspapers for decades. Their vitality - circulation, reach, revenue - directly effected same for our products. We had the resources and incentive to build and "give away" products and services to our partners as it was clearly in our interest.
Lessons learned included 1) even gratis is not sufficient positioning for adoption. "Gratis with guaranteed revenue generation" wasn't either: high-touch execution support and hand-holding through the process is what made it work where it did. 2) just because people are smart and capable of executing doesn't mean they will; if they were capable and still hadn't yet executed, they almost certainly would not without some fundamental shift.
Illogical, IMO, but those realizations have made other opportunities recognizable.