It's pretty obvious at this point you are dead set on making this floor waterproof and though you normally wouldn't need it to be, making it waterproof won't hurt anything either.
YOU CAN ONLY WATERPROOF ABOVE THE CEMENT BOARD!That is, if you've already purchased your Hardi, and have it cut to size, install into a bed of thinset, screw it down, tape your seems and then coat it with a topical waterproofing membrane. You keep referencing Home Depot's products, so that would mean you would use Redgard. On Hardi, I give it a primer coat of diluted redgard, 4parts water to 1 part redgard, since hardi is so thirsty, just a really thin coating, then I go at it full strength Redgard. Must be 47mils thick dry or just over 1/16" thick when dry. Use foam backing rod in your perimeter expansion joints to plug them up (found with weatherproofing stuff and used to plug deep joints before caulking) and Run the redgard over that and up the walls a couple inches, embed fiberglass tape in the wall intersections in your first coat. Lowes also sells a liquid waterproofing product from Laticrete called "Floor and wall watertight"
If you haven't cut up the Hardi yet, return it and buy Ditra. Find a tile shop near you that stocks Kerdiband and install the ditra and install Kerdiband over the seams and at the floor wall intersections. You could also order the Kerdiband from HD or online at [www.tile-experts.com] or [www.tileprotection.com]
If you use Schluter Ditra, you can use Versbond to install the Ditra to the floor but for Schluter's warranty, you would need to use a different thinset to install the tile. Head over to Lowes and get "Megabond thinset" to install the tile. Don't buy the jug of megabond additive.
You could also use Noble CIS as your underlayment in which case you would set the membrane and your tile with Versabond. You can order it from [www.noblecompany.com]
Noble Products or Schluter Products get used on the floor in place of cement boardWe're almost into November, the wife and daughter will be back in December. They can't just run outside and go behind a tree, or if you live in snow country, proudly write their name in yellow in the snow.