d&d is kind of shit for almost everything. its only good for a narrow pulpy sword and sorcery adventure that asks no interesting questions.

and bitd/fitd is much better faster more adaptable for basically any pulp trash with like 5% adaptation.

d&d is unusable for intrigue or investigation that isn't fully railroad. the concept of the individual is so central, a player representing anything else is basically unplayable. there's almost no consideration for the theatrical or collaborative writing elements of the genre.

you just haven't played any interesting ttrpg's. you should!