Going back to the OP, I like D&D when its medievalish, because medievalesque is both well known and far away in the past for it to be cozy, familiar and not getting too topical.
Science fiction is inherently topical and can get very opinionated quiet fast. It turns into either a critique of current society or a desired future society. And well, while there are cool things to see in sci-fi, it ages poorly.
Another contrast is the age of Piracy, and well, I just don't find it all that relatable or fun. For many people that is indeed cool, but it does nothing for me. Outside of the Princess Bride and a one-hit-wonder band from the early 90's there is not much pirates in my entertainment. It's ok if people like it, but not for me.
Then we have Renassaince, early modern age and Victorian Fantasy. And yes, they all have something going for it. Steampunk and clock punk have their charm, and I've even have made a short adventure idea based upon a Holmes/Reaper idea under the gaslights. But these work best for me as the occasional alternate flavor for variety, too much for everyday play.
And finally, there's the matter of guns. They are either game breaking or immersion breaking with little in terms of balance. They also ring too close to home, as gun violence is a problem in my country. So, I really can't find meaningful escapism in a game that features them prominently.
Medieval/Fairy Tale is then a happy medium for me. One giant sandbox where I can go from very idealized to quite gritty and explore a lot of different fiction genres without changing the basic assumptions, and easily communicate the basic assumptions. It is familiar. It is cozy, and well, for beter or worse I grew in the Western hemisphere, and I'm unashamed of that part of my cultural baggage. At the same time, I'm in a position of basically no cultural power, so I feel completely unapologetic about the unsavory parts that have been brought here (and in similar threads like the one about the paladin). I don't care if my escapism recreates colonialism, I'm too unimportant for that to make a difference, and I don't care what a group of first-worlders think is acceptable fantasy for me to have.
Also, Spanish is my Mother tongue, and the two foundational texts in the Spanish language are a cantar de gesta and a novel about a guy who grew mad from reading too many books about mediaval knights! I mean, I would like to game on settings based on Antiquity, or even in precolombian times, but these have their challenges on communicating basic assumptions. (And I don't like part of my heritage used as just a superficial exotic flavor, plus with that one, I'm actually in a position where what I do can matter and affect living people)