Is it really a good deal?
I don’t think so.
It’s a good deal for most responsible people with a steady source of income who want to live in an area with reliable property values. If their income goes up, they can easily make additional payments to pay off the mortgage early if they want to save some money on the long term interest payments
If one isn’t good with math, then I agree it can easily become a bad idea.