Flying in close to Mesa Verde would be most likely Durango, be a bit more expensive and a rental vehicle could be very expensive especially the drop off fee. Maybe look at Denver, Las Vegas or Phoenix.
Albuquerque is closer and has enough competition for good rates.
A suggestion: Arches National Park, Monument Valley (a good ride on horseback is possible from "Wild West Trails"), Antelope Canyon (visit both the North and South Canyons), Grand Canyon, Sedona, Flagstaff, then some of Route 66 (what's left of it) to Barstow, continuing to the coast via San Luis Obispo, then take Highway 1 along the Pacific coast to San Francisco.
