The sport known for the "drama of the missed field goal" is American football. This term often refers to a critical moment in a game where a player attempts a field goal, and the outcome significantly impacts the game's result, leading to intense emotions.