Like Olo said - giants are most closely associated with fairy tales and mythology. They’re a cliché, and hard to portray with a degree of legitimacy or seriousness. Giant monsters, it’s easy to get them over the uncanny valley - giant humans, not so much! Almost exclusively awkward and upsetting in live-action, I’d say!
There are a lot more giants in media than I think you’re letting on. Comic books, cartoons, and video games feature giants with relative reliability (sometimes they even make it to live-action, if you’re lucky! Aforementioned awkwardness notwithstanding); I can’t think of anything mainstream “about” giants without reaching back to the truly awful Jack the Giant Slayer film, but they’re in the periphery of DC and Marvel comics, the God of War series, One Piece, and plenty more. And if you’re willing to step outside of mainstream just a scoche, there are a lot of indie stories about giants! I’m big into comics, so I can recommend things like 3 Story, Vei, and any number of stories with Giant-Man and Atom Smasher and such - but I’m sure anyone who reads real people books, like, with words and no pictures, can find you a novel or two. (Edit: I should’ve read all of your post before replying, you did in fact say this. Also you said not to recommend anything. oops)
…don’t be let down by Google and YouTube searches, by the way, I remember when searching up “giantess” used to return results exclusively for the Giantess Geyser in Yellowstone National Park


