Is doing MBA in India worth it?

Do it in India only if you intend to continue to live in India. Otherwise no one knows even IIMs outside of India.

If you plan to move abroad in the future, do it from one of the top B-schools in US/Europe, for your MBA to have any value internationally.

Top colleges-Yes Go for tier 1,2 colleges