Move over, Cotswolds, right next door is the low-key, more-bang-for-your-buck region with vast mansions, rich locals — and Claudia Schiffer and Charles Spencer at Althorp for neighbours