Here we do have grape tomatoes . . .
. . and strawberry tomatoes, and camparis, brown tomatoes, heritage tomatoes and many more. The cherry tomato, however, is much less seen today than it was. It was once heralded as the savior of flavor in tomatoes, but the growers quickly learned to make flavorless cherry tomatoes.
The grape and strawberry tomatoes are smaller and very good eating, not too sweet at all, but you wouldn't make sauce from them, too much skin to deal with.
In general, market tomatoes, even with a few days of countertop ripening, are not very good for sauce - you're usually better off with canned tomatoes. I did, however, make a very fine sauce a couple of months ago from a pile of large cluster tomatoes that were getting a little over-ripe on the counter.