Actually I think under certain circumstances you CAN see bullet trails. The spotter in a 2 man sniper team will watch the vapor trail left by the bullet as it boils the air in its wake; thus allowing him to call out adjustments to the shooter.
Of course we're talking about high-caliber rounds traveling thousands of feet :)
The Hollywood stuff is way exaggerated, but it sure looks cool!