Thrill-seeking drivers, road-weary residents clash over rebirth of 'the Snake'