Back in Việt Nam I could pick the ripe ones in the market, but since I moved to South Korea, they are hard as rocks. I often have to buy tomatoes a week or two in advance and wonder about your situation. Some are too green and refuse to ripen even after a month.
Cherry tomatoes are still good, though not suitable for finer sauces that require peeling.
Where I am in southern Australia the tomatoes are ripe so that you’ve got to eat them within a week of buying. You can usually buy some ready to eat right now, or some that are a couple of days away from ripening, even though it’s not really the season for them here at the moment.