I think your idea of a unified sales tax database/system is spot on.
This is serious nightmare ... but much less so for a company of Amazon.com's scale than a potentially dangerous to it upstart.
(Note that I don't agree with charging sales tax on mail order purchases; the mail order companies do not benefit from taxes except, say, though that maintain public order, and that's party captured by the delivery companies they use which do pay local taxes (except for, I assume, the USPS, but that's another issue).)
That might be whats behind Amazon's change of heart. This will be difficult for them, but its probably impossible for smaller retailers. It might be expensive in the short term, but it protects them from competition in the long run.
Without endorsing the product, here is one vendor's product page: http://onesource.thomsonreuters.com/solutions/indirect-tax/s...
http://onesource.thomsonreuters.com/solutions/indirect-tax/s...
Also, if Reuters has excessive profits, someone will probably make a competitor. That said, it's basically a solved problem, except when companies want to hand wring their way out of paying taxes.
BTW, don't be ridiculous about "hundreds of thousands". Unless you mean thousands. Even TR in their sales literature only mentions 13k tax authorities [1]
[1] http://onesource.thomsonreuters.com/share/solutions/41686/br...
Amazon and everyone else involved in ecommerce would be a lot happier if there were a unified system/database for dealing with sales taxes in the US. Rates and rules wouldn't necessarily have to be the same, but there at least has to be one system with unified categorization of products and a unified filing mechanism which can be automatically queried, and as long as the merchants use that system in good faith, they would need to be immune to any sort of lawsuit or prosecution for not meeting the actual legal requirements of any particular state/locality.