No doubt Compton Abbas is in a more beautiful location than Henstridge and has great views and cafe, but Henstridge is a much better airfield now. It has a hard runway for a start, new taxyways, new hangars at a decent rate, fuel in line with CA & Dunkerswell, an EASA145 maintenance firm as well as FAA IA on site, the air ambulance etc...True the clubhouse is a bit run down, but things are in the pipeline to improve that - in fact the whole airfield is steadily being improved and shortly flight training will start as well as various other things.
The main reason CA is so anti-Henstridge AFAIAW is the fact that the Yak display team relocated to EGHS as they were offered better facilities at EGHS. Allegedly this was handled in a very childish mannner and I have heard stories that some people from EGHS have actually been BANNED from CA due to the fact that they are based at EGHS...for no other reason.