Tangentially, if you enjoy The Great Gatsby, you might also enjoy All The King's Men, which is a work of fiction that I think similarly richly described a swath of the American experience.
As for Gatsby, I think it's a great piece of fiction that invites a lot of readings, and everyone's invited to that ownership of the text. I think you can come away with the deeply shallow understanding of "the twenties were cool," and still be enriched by Fitzgerald's writing style.
I don't think anyone has made a good film adaptation of Gatsby and I don't know if anyone will, as long as it's adapted literally. The imagery and iconography of wealthy 1920s America eats so much of anything that tries to adapt it, that they tend to come out feeling shallow, and the writing is so dense that dialogue feels stilted and weird spoken out loud. You'd either need to, in my opinion, lean heavily into both, or abandon both, to make a good adaptation (leaning into both immediately feels like a Wes Anderson movie to me).
I think the best adaptation would be to do something like Jobs, where they just take a few scenes from the book and create a movie out of that.