Our last visit to Bordeaux was about 8 years ago and we stayed at Camping du Lac which is part of the Yelloh group. At the time it was on the ACSI discount scheme which made it reasonable cost wise. It was an adequate site which of course was very busy as I think it is the only Bordeaux site (I am probably wrong).
Bienvenue au camping Village du Lac ! Profitez de 13 hectares de nature à seulement 8 km de Bordeaux. Ce qui fait du Village du Lac l'emplacement idéal pour visiter tous les lieux incontournables de la Gironde ! Tranquillité et co
www.camping-bordeaux.com
I usually spend money on campsites if it is a large urban area as my perception is that the van would be more at risk of burglary.
It had at the time a bus service at the door to the city centre, or you could cycle to the tram terminus in about 10 minutes for a more frequent service.
Davy