The drive from Paris to the Dordogne is mostly rather boring unless you have several days and can get away from the autoroutes. What's your objection to driving from Bordeaux? Although Bordeaux airport is on the 'wrong' side for travelling to the Dordogne once you get round the often congested ring road and onto the A89 autoroute it's really quite easy.
You could check other airports you could fly into from Zurich or other places you plan to be - Bergerac, Brive, Limoges, Toulouse are all alternative airports either in or within easy reach of the Dordogne. Also check rental car choices - Bordeaux and Toulouse will generally offer more choice and more extended opening hours.
While we have not driven from Bordeaux to the Dordogne , we have picked up a car at Bordeaux airport and driven to the Gers region. We had no problems. As Celestina says , it is a long drive from Paris . Whether you choose to pick up a car in Paris , Bordeaux, Toulouse, you will need to get around and away from a large city. Another option would be to fly into Paris and take a train to Brive la Gaillarde and pick up a car there. But it is a smaller place and less choice of cars.
We always do some research on the route from the airport before we go. We are picking up a car at Lyon in two weeks and we have had a look at the route even though we collected a car there in 2016.
Good luck.Edited: 17 August 2018, 01:27
I actually don't think the drive from Bordeaux to St Cyprien is too difficult, to be honest! Once you come out of the airport, you simply follow the signs to get onto the "Rocade" which is a giant ringround around Bordeaux, like a mini freeway, and then you stay on the rocade till you get to the exit or 'sortie' that you want. So if you want to go via the tollway, you hop off the rocade at Sortie 26, and follow the blue signs on N89. Or if you want to go the slower way, without tolls, you hop off at Sortie 24, following signs to Bergerac, taking the D936 through the vineyards.
Sometimes though, in a weird way, the autoroutes are the easiest way, especially if you're not comfortable to drive. That's because you just get into your lane and stay there, all the way to each turnoff, as you need them.
But if you're not that keen on driving, then I would definitely not recommend a drive from Paris - as already described by Phirhon...long and tedious. A train or flight into Brive could be a solution though.
I agree with Cubsur - you definitely need a car to get around the area. You could take a train from Bordeaux to Bergerac on the same regional TER line that 107sharong mentions, and pick up a hirecar at the station there. But there's definitely no hirecar depots at St Cyprien itself, as far as I'm aware. The drive from Bergerac to St Cyprien is at least an hour shorter than from Bordeaux.
I have holidayed in st cyprien three times and found the easiest way was to fly into bezieres and rent a car