Note: I am leaving out the anthologies as well as the starter sets, and the smaller stuff like Kwalish, just for simplicity. Assume that "played through" doesn't necessarily mean "completed" but should imply more than a couple sessions.
Of those on the list, I have DMed Hoard of the Dragon Queen + The Rise of Tiamat, Curse of Strahd, Storm King's Thunder, and Tomb of Annihilation. I have also used pieces of Princes of the Apocalypse and Out of the Abyss but I didn't tick those. I started Dragon Heist but gave up on it partway through.
I am currently DMing Dungeon of the Mad Mage and Tomb of Annihilation (for the second time).
As a player, I've played through Curse of Strahd, Storm King's Thunder, and Descent into Avernus (heavily modified but still recognizable).
None yet. I intend to run Ghosts of Saltmarsh soon, and hope to one day run Curse of Strahd, Wild Beyond the Witchlight, and parts of Out of the Abyss and Princes of the Apocalypse (and maybe parts of Tomb of Annihilation and Storm King's Thunder, too... I really don't like the main plot behind the latter two).
I've run Curse of Strahd twice to completion as a DM and would run it again.
I'm about 2 sessions away from completing Icewind Dale: Rime of the Frostmaiden as a DM with one group, and about 1/3rd through it with another group. I'd run it again.
I have run Waterdeep: Dragon Heist to completion as a DM and would never run it again without serious financial compensation.
I am currently running Waterdeep: Dungeon of the Mad Mage as a DM and players have just reached level 3 of the dungeon. We're enjoying it but it is hard for me to believe we will really finish the whole thing.
I have completed Tomb of Annihilation as a player and loved it. I think I would run it as a DM but it's certainly a ton of work.
I am currently on an actual play podcast of Baldur's Gate: Descent into Avernus and we are I think about 2/3rds through it.
I have cannibalized bits from Out of the Abyss and Storm King's Thunder for homebrew campaigns, but only a few sessions worth of stuff from each.