Let's get it straight - your home is not an investment. While property appreciates in value over time, the best property to own from an investment point of view is a property that produces rental income as well as capital gain. Investment is something that should be done with objectivity and a focus purely on investment return and risk.
Buying a home to live in is a process clouded with emotion and consideration of comfort and lifestyle.
The best property to buy as an investment is unlikely to be the one you would choose to make your home.
From a strictly investment point of view, the home you live in should be the kind of house that would make a good rental property; that is, at the lower end of the market in a handy location.
Instead of investing a large amount of money in one property to provide a lavish lifestyle, buy two cheaper properties; one to live in and one to rent.