Designing a home can bring ambition, emotion and financial reality into sharp focus. Caroline Shortt talks about architecture, property and knowing when enough is enough.