A characterization of strong wave tails in curved spacetimes