Gun Shy (2000)

Charlie (Liam Neeson), a legendary undercover DEA agent, has suddenly lost his nerves of steel. On the verge of a career-induced mental breakdown, and in complete fear of trigger-happy Mafia leader Fulvio Nesstra (Oliver Platt), Charlie seeks psychiatric help and finds himself relying on the support of an unstable therapy group, and nurse Judy (Sandra Bullock), just to get through his work.

But the stakes are high, with Charlie in the midst of nerve-jarring negotiations with psychotic mobsters and the Columbian cartel, and everyone wants the money. Charlie has got to keep all the pieces together if he hopes to make it out alive one last time. That is, if he can ever retrieve his intestinal fortitude.