I certainly share certain character traits and life experiences with some of the characters of that show. That's a part of why I like it.
It's like when any show features a group, there will be people from that group who do not like the way they're being depicted.
It's like when a show features black people, there are always black people who get upset because they're not like that or when a show features asian people, there will always be asian people who get upset because they're not like that.
In these cases, just like with nerds and geeks, some are like that and the ones who are, are the ones about whom an entertaining show can be made.
Virtually nobody is going to watch a show featuring a middle-class, college educated black dude who manages a small restaurant unless there is some other hook. Virtually nobody is going to watch a show about a middle-class, westernized son of Japanese immigrants who works as an accountant, unless there is some other hook. Virtually nobody would watch the Big Bang Theory if all of the characters were average looking, well adjusted people who have passable social skills and just so happen to be very smart and work boring jobs.
Sometimes a cigar is just a cigar and sometimes a TV show is just a TV show. If you can accept that the message isn't "This what they're ALL like" and that it is "This is what THIS group of people is like", I think you can reduce the amount of discomfort you feel.
The professional side, the science, is held up with great respect and considerable accuracy. These guys are doing really neat stuff at the university and we get to see their enthusiasm and success with it. That's very cool and appealing and a positive light on STEM professionals that's uncommon in popular culture.
The personal side, the geekdom, is held up for mockery. The show brings up comics and science fiction and video games mostly as punching bags for the girls to trash and feel socially superior. That's the negative vapid stereotyping that critics complain about.
Whether you like TBBT depends on which of those has more impact on you. If you like the science and don't mind the anti-geekery, you'll like the show. If the anti-geekery hits too close to home, you'll hate it.
(Side note, I'm conflicted on whether to participate in this subthread. It's Reddit-style topic drift on intentionally misinterpreting the submission title and ignoring its content. But there's good discussion happening here anyway.)
The first 3 seasons are quite funny and with plenty of sciency stuff, but it starts declining around the 3rd or 4th season. The season 4 episode featuring Sheldon's robotic telepresence and the Steve Wozniak cameo is perhaps the high point in humor, after which the whole thing goes pointless.
2) It's not like the non-indian guys are really that much better.