I've been a few times for work and pleasure...
You'll either love it or hate it.
And as soon as you get off the plane you'll know one way or the other.
I love the place. You could spend a lifetime in India as a tourist and never see all of the sites. Most Indians are great people. Generally they have no issues with foreigners but there is a minority group that somehow finds itself at the centre of most "issues".
I don't really want to name them in OT but I'm guessing most people will know who I'm writing about.