No, the closest was at the second and third Borg invasions. He just freaked out alot, and he let his emotions cloud his judgement. He is a civil Star Fleet captain in his 60s and 80s; he can control himself.
However, there is an altered still image from the TNG episode "Devil's Due" where he appears to give the finger. But if you watch the episode, you'll see that he has more than one finger up. It happens within the last 10 or 15 minutes of the episode.