Graeme McDowell ended a 40-year European drought at the US Open and landed his first major on a dramatic final day at Pebble Beach.