You have been given the essential information about Bordeaux, the village of Saint Emilion could be suitable, both for wine tasting and for the village itself, classified among the most beautiful villages in France.
Note that there are dozens of Bordeaux estates that offer tastings, not all are great Bordeaux wines. Only the appellations with the mention "Grand Cru" are wines classified among the best, there are about 60.
Beware of alcohol tests if you drive, the limit is about 2 glasses of wine. Above that you are liable to a fine of €135 and no longer have the possibility of driving. Taste "like a professional", spitting instead of drinking and everything will be fine.
About Rocamadour, I confirm that in July you will be among the hordes of tourists from all over Europe who come to visit it, many of whom arrive by coach on an organized tour, stay an hour or two, buy trinkets made in China and get back on their coaches. Also avoid restaurants which are tourist traps.
On your way to Rocamadour you will pass through the Dordogne valley which has some typical villages classified among the most beautiful villages in France which are worth a visit and are not mass tourism destinations.
The best way if you want to stop and do some Kayaking is to take the departmental roads D936 then D660 along the Dordogne river and not the A89 motorway. You will take the scenic roads and via the villages of Beynac and Cazenac, La Roque Gageac and Domme.
I see that Allan still remembers his adventures using a GPS on the small roads of Dordogne. Don't forget his advice! LOL
That being said I think it will be very difficult to have enough time in one day to kayak/canoe all the way to Rocamadour.
There are kayaking/canoeing bases all along the Dordogne river, however this activity takes time, at least 2-3 hours plus the transfer time by minibus to get you back to the starting base, and in July this activity often requires advance booking.
In my opinion the best option would be to skip Rocamadour which is definitely not worth the time lost in travel and the hassle of finding parking, especially if you are visiting the other villages closer by.
On this map you will find information on visits and activities in the Dordogne and Lot valleys, including some kayaking/canoeing bases and even local winemakers who offer tours and tastings.
https://www.google.com/maps/d/edit?mid=1OdPOg8AgsNn0Jlv1cNHkujaWv9p_Jpc&usp=sharing