Text this: Rips and regular future scenario with holographic dark energy: a comprehensive look