Block’s Farm Market, in Romulus, Michigan, is a great place.
I particularly liked the way they sell sweetcorn: a tractor drives in from the nearby field towing a couple of trailers, and you just help yourself. You pack as many as you can fit in two large bags, for $5. It’s also, I have to say, perhaps the best sweetcorn I’ve ever tasted.