Mackinac Island, MI is fantastic for a tiny little town because of the whole "no cars" thing.
but it's essentially a historical theme park with an old fort and horse & carriage rides instead of rollercoasters and ferris wheels.
so it's not really what this thread is about.
but the no cars situation is an extremely wonderful and rare treat to find in the USA.