Most people grow sweet corn in their gardens, so they won't be growing these.
There are heirloom sweet corn varieties, but they have to be cooked in minutes/hours from harvesting to remain sweet.
As far as the starchy corn, you won't get a lot of flavor difference.