In similar situation but considering a used one instead.
The Mazda 6 grand tourer is a wagon and wouldn’t be like your typical hatchback car. It’s unique as most people in Malaysia wouldn’t consider a wagon except for Audi RS6.
Both are gorgeous, Mazda’s maintenance cost would be slightly higher. The Camry is a very safe choice. It’s a Toyota, it has better resale value. If the above is not of your concern and you want to stand out a little bit. Go with the wagon! I know it would be my choice if I’m in your position

Btw both are great for family usage.
Sent from my iPhone using Tapatalk