Camino Tortuoso
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