One character being played by three different actors (either that, or three characters being so similar I confused them as the same character despite being three different actors) is hardly charming IMO.
Longer form stories, such as Game of Thrones (where Azor Ahai, and other such plotlines are literally killed off) are probably more entertaining. It sucks to see a fan theory turn out to not matter at all, but not everything ends up being relevant to the conclusion.
I don't think a 2 or 3 hour movie has any room to dwell on unimportant details. Anime and miniseries do have that time. We can watch Goku mess around with Princess Snake or Krillen get his Namekian power up (which doesn't matter for any fight, but is good development for the character in isolation).
That's probably the charm of Cowboy Bebop. There's so much detail and none of it really matters. The interesting story happened like 10 years ago (in universe time). That's be my pick for a show / story with very little Chekhov gun going on.
-----
Chekhov gun is probably contrasted with Red Herring, which is explicitly a detail that not only doesn't matter, but purely exists to mislead the audience. Any Chekhov gun heavy plot needs red herrings to balance things out, otherwise it's too predictable.