Reserving specific sites in public or private camps is contentious. With our without fee to do so, the reservist has the right to demand the site they reserved. Sure you could buy them out, why did they reserve that site, why didnt OP reserve it for the whole 14 days to begin with?
Campsites are not like a hotel room, where they are all the same or next door, just as OP opined, it may not be so much that particular site as it is his backing skills. That issue is one that plagues every camp.
If leaving requires a wiggle, backing in can take more time, more wiggles. learn and get more proficient each time. The lawn chair and a beer crowd do not help, they discourage. Next time you see an inproficient driver, insted of derision, offer help. Rarely Very rarely, was my proficiency in helping to backing declined. Even then it was a 'I have to learn this ' attitude.
A common practice in private camps, that we detested and did not charge when we owned our camp is a Site Lock fee.
In looking back, how it affected our occupancy definitely added to our work load , loss of occupancy and profit margin. It is no different for public camps, If you want a specific site, bookit for all the potential dates pay for them. No camp , cruise ship, hotel, airline, of any lodging or transportation venue will or can refund your unused portion of your reservation. That space was reserved and held for you. Conversely, if you did not reserve the entire time, on that specific site it is open to others who may see the attributes , thats why they reserved it. as well.
We have favorites in many camps for the same reasons.