I know that it's only a battery, and it isn't rocket science. But since the X5 may not get driven daily anymore, I wanted to find something that has the highest possible RC and relatively easy to get my hands on for a reasonable price. May not really care much for the highest CCA or CA as long as it meets OE specs since I may head up the ski resorts in the California winters.
While I understand that there are less than a handful of battery manufacturers, their specs still varies widely among them or even within them. A "flooded" battery isn't totally off the table as my current 5-year old is a "flooded" H7 DLG from Autozone. It's just that for approx. $10 more, I can get an H8 AGM, which somewhat makes it a no-brainer (at least for me) to go with an AGM.
Don't have memberships to Sam's Club or Costco. My local NAPA doesn't have much on their shelves

Pep Boys and Batteries Plus usually runs $30 or more for an equivalent battery. So it's just a toss between O'Reilly's and Autozone.
My original concern was to see if anyone had ran into any type of issues or see if there were any downsides in using an AGM just in case I decide to head in that direction. But additional research had shown no downside to an AGM (other than being more expensive) and MD is the living prove of that

, It just made my decision much easier.
In the end, I may just have over-think all of this. Thanks for all the inputs and taking the time to hear my long thought-out processes. This is what 25+ years of engineering will do to you