A 15yr tenure is a sweet spot for most people. Anything above might mean you can't afford it. Anything lower means that if you can afford it, why give up your cash on hand? Prepayment charges are banned by RBI anyway. Pre-pay any time.
Longer tenure == higher interest (net of tax benefit)
Yes. That's true.
It's also the cost of capital, and peace of mind.
I took a longer tenure, collected cash and didn't worry too much about the loan, and one fine day went to the bank and paid 50% of the principal outstanding.
Did I pay more interest? Yes, marginally. Amortize over a few months/years and you'll realise it's (very) low 4 figures of extra interest.
Did I ever worry about the loan -- Never.
Go for any bank that gives you 8.4% or better rate.
Make them compete against each other.
PSB >> Any private bank.
Axis is top notch. HDFC is a miss or hit (mine is with HDFC, not a miss, but probably lucky)