>>15086207He is the most of his time wrestler ever, the gap between his popularity at his peak and how well he'd translate to a modern audience is the widest of all of the other all-timers. Of those you listed, the only one that would have close to as much trouble getting over would be Taker, and he has enough skill in the ring and a good enough look/gimmick to make up for it. Hogan was middling in the ring in a time where work rate is valued a lot more, and he could be pretty fucking awful on the mic at his worst despite having natural charisma. Of Austin, Rock, Sting, Foley, Taker, Bret Hart, etc, Hogan is the only all-timer that I can't see getting over today without being near unrecognizably repackaged.
New audiences can't really look back fondly on his in-ring stuff, so what you're left with to reminisce on if you're below the age of 40 is Hogan-era TNA, the NWO petering out horribly due to Hogan's creative control, the Gawker tape, the weird constant lying, and burying, politicking, or otherwise screwing over a lot of talent in his heyday, including many other peoples' all-time favorites like Shawn Michaels, Bret Hart, Taker, Sting, Randy Orton, et cetera. There's just not a lot to remember fondly, as his work shows its age and younger and younger waves of fans get into wrestling.