I don't mind the product placement, because, as you said, makes the situation more realistic and believable. It's quite silly to see someone, for example, to grab a soda, where the name has been taped over (knowing full well what brand the product is), or completely making up a brand (taking a big gulp of "kooky kola"). Even funnier still, was the use of the black and white "generic" brands of products back in the 80s.
I say, if it doesn't go completely overboard (like the Ford Escape reference that people are using a lot lately), I have absolutely no problem with it.
-Terry
More than once, Molly has voiced her opinion about product placement. To sum, it seems that she isn't against it, but she often makes fun of it when it is too obvious. For example, the Ford Hybrid on Alias. I hope I am being accurate in describing Molly's opinion.
What do the rest of you think?
I don't have a problem with it. I think it often adds to the realism of the show because the characters use real products, rather than made-up ones. I'd rather see a show with a product placement paid-for than have to pay to see the same show without the product, in most cases. I don't mind if it's obvious. I will tell you that it doesn't change my opinion of a product, and mostly it doesn't, but I did find myself wanting a cell phone after I kept seeing everyone on TV using them.
My only objection would be when the writers of a show actually change the story to fit the product placement in some way. Like if the whole episode of a sit-com was about a character's quest to buy a certain car, or something like that.
I want to hear what others think about this.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic