the categories most wanted are also the categories with the most competition, so keep this in mind. Sometimes it's just better to choose a category that goes under the radar (some obscure arts, crafts or hobbies for example, or some low search volume illnesses and diseases, etc). In such cases most marketers usually don't go in because they're either too low traffic'd so they don't generate enough money to satisfy their big egos, or they simply don't know about them, or they can't create enough content in these small niches because they're not familiar with them, or whatever.
The point is that sometimes it's better to go with a small niche if you know you can dominate it with your expertise and if you can find a product / service to sell in these niches that nobody else does. Sometimes, if you can get even 1000 visitors a month in one of these niches and 10% of those visitors buy your $17 product this might be enough for you to live happily under the radar (it would be enough for me, for sure).
But if you absolutely must go with the big bucks niches then some of the most high paying niches are finance (everything having to do with money like banking, loans, investment, crypto, etc), health & fitness, relationships, travel, web hosting, legal (attorneys and lawyers).
Generally, everything that is evergreen and in which people spend money year round is a good niche to get into because there's always traffic in those niches. But they're also more competitive, so you have to decide alone which category is best for you: high traffic'd niches with high paying bucks but which take more effort and investment to make money with, or low traffic'd niches but which you can break into faster and with less effort but with also less earning potential