I remember a big fuss made about Daniel Craig drinking a beer bottle in SKYFALL. To be fair, in the film itself, I thought it fairly low key.
The 10 Most Shameless Product Placements in Movie History http://www.cracked.com/article_16574_the-10-most-shameless-product-placements-in-movie-history.html