A more popular drone shot as of recently. Sunset will give you golden light hitting the canyons on both sides while sunrise will be directly behind you in frame.

Do not expect the water to be bright blue or green here. Majority of the time the San Juan river is brown.

You can launch from here: 37.194791, -109.865400 right along the highway, or if you have clearance, can launch from here: 37.176042, -109.849260