We had actually first reserved a mid-terrace house and then switched to an end-terrace house. In our case, this makes practically no difference regarding the lighting situation (two windows have moved from the roof to the facade, otherwise the windows on the upper and ground floors are identical to the mid-terrace house). (We do find this a bit of a shame, but that’s another discussion). The thought of having two direct neighbors didn’t immediately deter us either, even though our personal environment did say "are you SURE?!" so maybe that influenced us in the end... otherwise we found the accessibility of the parking space and garden better that way, but that really depends on the situation on site. And the extra cost was low enough (I think it was 17-18k less for the mid-terrace house with the same plot size, I don’t see the prices now... the mid-terrace house with a 20sqm smaller plot is 20k cheaper than what we are paying), so that we ended up thinking "I believe we can afford the extra cost, let’s just take the end-terrace house."
Just to say: at least it was never ruled out from the beginning :)