but they definitely mentioned it by name and zoomed in on it pretty close.

That's the kind of thing I hate.

It's fine to have the characters playing a video game on the show and someone say, "oh, <insert name of cookie-cutter sitcom character here> just got his new Xbox for christmas, so that's why <insert cookie-cutter sitcom situation here>." To me, that's a perfectly valid use of product placement.

My problem is when the pimping is blatantly obvious like you described, and like what I saw on The Sopranos. That rips away my suspension of disbelief and ruins the experience of the show for me.