Cop film, 1990s and plot?

I can't think of the title of a film where a cop, or a detective or someone finally gets this criminal, and the criminal engages in a shootout in a cabin or small home near some body of water. The cop is a famous actor, I can't be certain, but I picture James Caan or Jerry Orbach when I think back. Eventually, said cop is shot, and walks out of the house, the gunman finally dead, then falls on his knees and finally dies a short distance from the door of the building.