Chevrolet's move to a mid-engine layout has paid off in spades but the final C7 Stingray still delivers serious performance.