Yes - but this mainly comes down to the varieties that you grow. You can grow varieties that are very tasty and are usually sold in the premium tier. And you can grow high-yielding tomatoes with less taste.
>Personally, in my area tomatoes are cheap enough to not think about the price, but the products widely available from supermarkets taste like water
Where are you based? High-tech greenhouses already supply a lot of premium-tier produce in Europe but there is an undersupply in the US/Asia.