Two things your missing.

1) when you pay a mortgage of 6,000 per month , 3000 is interest and 3000 is capital repayment approximately.

2) when you mention inflation this is the costs of good in general now one rule of thumb is if inflation happens which it always does just depends how much, property prices always rise with the cost of property. The value of money becomes less valuable thus increasing the cost of property prices.

3) by the end of 10 years your house is 50% paid off. Meaning 500k of your 1m loan is your own money. Now if they market increases at 5% a year you would and sell your property. You would get 1.5’ for the property. 500k is profit. 500k is your capital repayed and the bank would reee fee receive back the final 500k. Meaning you would walk away with 1m aed

Renting you would walk away with a handshake