You are buying from the wrong stores. Tomatoes can be easily grown locally in greenhouses, negating any reason to pick them green. This is where my costco tomatoes come from. Note they are not green when picked.
http://blogs.theprovince.com/2015/03/04/b-c-s-booming-greenh...
Are people planning on making guac buying a week ahead of time?
Stores should really start doing this themselves... wait until they're just about ripe, then package them in sealed containers (so shoppers can't poke and bruise them) and keep them refrigerated. Obviously more effort which will add to the cost, but I'm guessing the average consumer would happily pay a bit more to get ripe avocados on demand. Otherwise you either have to really plan ahead or go on a search for the rare unicorn that is a ripe one.
The reason is that canned tomatoes usually come from the leftovers and blemishes. When they pick a field of tomatoes (green), quite a few are left behind due to being too small, strangely shaped, etc. These are usually allowed to ripen. From what I understand, those are what canned tomatoes most often come from, as they're the cheapest.
No one cares if a misshaped or bruised tomato gets canned. It will still taste about the same. Therefore, you can ship the tomatoes closer to ripe, as you're not worried about bruising.
On a side note, canned tomatoes are actually usually very good if you buy a respectable brand. The bargain brands vary a lot more. Honestly, unless it's late summer and I can get great tomatoes, I make salsa from canned tomatoes instead of fresh. (Note: this is for things where I'd be fire-roasting the fresh tomatoes anyway.)
One of the biggest reasons tomatoes from the store taste so bad is that they're picked completely green. The second is that the commercial varieties are bred to have a pastier texture and be tougher to stand up to shipping. The third is that tomatoes don't stand up to refrigeration without a change in texture.
My uncle grows tomatoes commercially in southeast Tennessee. If you actually let the commercial varieties ripen all the way and don't refridgerate them, they're pretty good. They're better than the anything you can buy at a fancy grocery store. They're not as good as homegrown brandywines, but they're on par some of the popular hybrid varieties, and will beat out any store-bought heirloom (e.g. a store-bought brandywine).
However, when any tomato is picked to sell in bulk, they have to be picked completely green. Otherwise they'll be too badly bruised to sell. The "vine ripened" tomatoes you buy in the store just means that they cut off some of the vine along with the green tomatoes.
The site is down, so forgive me if I'm pointing out something that's mentioned there. At any rate, in my opinion, commercial tomatoes suffer more from being picked completely green so they'll survive shipping than anything else.