They led into Picard mowing down Borg with a Tommy gun in First Contact, so they're a-okay with me!
Incidentally, I just watched The Big Hit, which came out in 1998, right around the time that In The Pale Moonlight aired, and it features Avery Brooks chewing scenery as a cartoonishly over-the-top mob boss, so I like to pretend that it's a holosuite program he ran to loosen up after the events of the episode.