The sea‐level conundrum: case studies from palaeo‐archives