I very rarely use giants aside from Hill and Stone giants. Hill, because they're still small enough to be plausible to fight with the weapons PCs use, and don't particularly seem heavily-derived from some historical culture, and are an okay to just drop in to a campaign without particularly changing the tone of it. Stone because they're weird, kind of mystical, and really their own thing - their portrayal in more recent editions has been pretty good honestly, and they make for a great kind of "confounding factor" or odd element in a scenario.
I don't have much time for "IM A GIANT VIKINGDWARF WHO IS ON FIRE IM SO METAL" or the rest. They start getting bigger (so less plausible feeling - I think it's very different with humanoids to non-humanoids, note - players I've played with definitely notice the issue of say "hitting their ankles" more with humanoids than dragons or the like), and also just a lot more boring in terms of their vibes and also somehow become like, overspecific? If that makes sense. Like there could be a Viking myth-centric/inspired setting where Fire and Frost Giants make a ton of sense, or even were vital, but I feel like they're a terrible fit for every game of D&D I've ever run, and feel really uncomfortable to say, situate in the Forgotten Realm (even though they specifically have places they live!). I could massively rebrand them/reculture/restyle them, but like, it's a lot of effort and why? I don't have any particular affection for giants or elemental-themed beings!
(Cloud are kind of okay because they're so weird too, but they're too big and peculiar for me to want to really use them as antagonists - I've used a couple as essentially quest-givers or NPCs players weren't intended to fight - and indeed they didn't.)
"Keep Giants Weird" I guess is what I'm saying for myself (apologies to Portland and/or Austin).
(As an aside, I totally get that some other people like the other giants, and again, in the right campaign I could see it - though I'd still prefer them a bit smaller - but I'm glad D&D has somewhat sidelined giants as a whole for most of the time I've played it, which thus makes them feel very optional.)