Hi Naio,
AGM starter battery does have low self discharge rates--but the problem is modern chassis have LOTS of parasitic loads.
I got around that with solar and a trik-l-start.
That said, the low internal resistance allows AGM to charge faster to a higher state of charge than flooded. It also means that a partially discharged AGM has a better chance to get the vehicle started than a flooded of the same capacity.
I ignore the battery replacement charts and always put in the jar that is the biggest and meanest that will physically fit.
The ultimate if you can afford it and don't live where it gets cold is LI.