Last summer we rented a house in La Roque Gageac from the Right Vacation rental. We had a partial river view. Town is packed daily for the tour boats and the kayaks. Very centrally located to prehistoric sights and about 20 minutes or so to Sarlat. We could see Beynac and Domme (cutest town)
from our patio.
Just remember that distances might be small between sights, but driving time is much more than you would expect. We were told by several people that is would take us 2 hours to drive to Toulouse. It took more than 4 hours to go 95% of the way and another 1.5 hours to find our airport hotel.