Mafia II (2010) currently has the world's best physics model for gravity, acceleration, driving and destruction of parts of cars (exact models of physical characteristics of dozens of types of historical cars), buildings, piling up of debris, ashes, broken glass on the floor, people, friction, fire, smoke, optics including complicated absorption and reflection models off different types of metals on the cars' surface, and everything else.
In all those respects, it was a huge winner, as expected from a similarly groundbreaking Mafia (I) in 2002.
However, the play fun itself is limited as people often think that there are not too many things to nontrivially interact with in the city and the tasks form a completely linear sequence which is often considered boring - even though this was the Mafia II's plan from the beginning because this leads to much more organized, movie-like experience. Mafia II - and dozens of other games that exist today - uses NVIDIA's PhysX enhancement of the physics calculations by graphics cards, see e.g.
http://youtube.com/watch?v=GMHeIGjLZ9I
If you want a more impressive, financially unrealistic but physically valid scene with thousands of barrels that are falling and exploding, see Crysis Physics
http://www.youtube.com/watch?v=YG5qDeWHNmk
which still remains a benchmark.