I have a masonry wood burning fireplace and chimney. An oversize metal cap is on top of the chimney. The tile to the brick is sealed with mortar with no cracks.
When it rains real hard, I get water dripping down around the damper. I gave up about 3 years ago and live with it. Sure hope masonry doesn't rot!