My favorite local farm stand (Gilbert Farm, Rocky Hill, CT) grows fantastic butter & sugar corn. Specifically, it's Providence, one of the TripleSweet varieties.
My second favorite corn this year was another type of TripleSweet: Honey Select.
(Q-P Farm Market, Portland, CT)
You may not even realize you're eating it unless the people at your stand talk about it or label it as such...but if you love sweet corn, you owe it to yourself to ask the folks at your local farmstand if they carry any of the TripleSweet varieties.