How do you say 'winding road' in Spanish?

camino glorioso

Él está en la final de la carretera is the best way to say "he is at the end of the road" in Spanish.

One translation of "red road" would be "camino rojo". There are many ways to say "road", which is the "camino" in the phrase above.

carretera de acceso

camino real