Confronting Theory with Experiment: Puzzles, Challenges and Opportunities in the LHC Era