In general, I found that I tried to follow what "they say" when it comes to an awful lot of things about raising kids with my first born... then came the second child and I woke up to reality and was more lax... now I have a third child and all of the cliches are pretty much true about the 3rd child. I did not boil his bottles, I did not stress over every single sniffle or cough when he was an infant, I did not hold him like he was made of glass when he was a newborn, and so on.... and I pop in a DVD sometimes when I need to get something done! (he's 3.5 years old)
Having said all of that, TV does not melt children's brains. It is your decision if you want to allow him to watch any at all, how often, the duration, and types of programs you expose him to. No, you don't want your 2 year old to watch shows that have values which don't fit your family, but I take issue when parents feel the need to shelter their kids from the world. (I'm NOT saying that you're doing this....just making a general point.) For example, I think it's AWFUL for anyone to say "shut up", so if someone says it on a show my kids are watching, we use it as a teachable moment and say what a horrible thing that was for that character to say because we don't speak to people that way. Just as you can use parts of shows to discuss educational things (like sit with him while he watches Sesame Street and help him learn the letter and number of the day), you can also use things you wouldn't want him to see and hear as ways of letting him know these things exist and talking about YOUR family's values.
Depending on your values and religious beliefs, you can start with something like a Veggie Tales video and go from there. Where I live, there is a station called Qubo-- it was started because someone didn't like the types of cartoons and shows supposedly meant for kids that has values they didn't like, so they show cartoons and other kids shows that have "good values".
......... Or............. do no TV! My kids watch the occasional DVD, PBS shows, or Qubo, and my older kids (5th and 6th grade) have 2 prime time shows that they watch.... but otherwise the TV is OFF in our house when my husband isn't home. (My husband is a channel flipper...drives me coo coo so it's so pleasant when he works late most nights and the TV is off--haha!!)