There is no best dressing.
The question assumes there’s a ranking. Instead, it’s a matching exercise. After a full assessment of you and your wound, the clinician needs to consider many different factors before choosing a wound dressing — including how well it absorbs fluid, whether it keeps the wound moist, how easy it is to apply, how long treatment will last, and cost.
Before any dressing goes on, the clinician assesses: how the injury happened, the risk of contamination, possible injury to deeper structures, underlying nerve or tissue damage, poor blood flow, tissue swelling, your tetanus status, how much tissue was lost, and whether there is infection. Most of those can’t be judged by the person with the wound.
Fluid is the clearest example. Wounds with a lot of fluid can be managed with foam, hydrocolloid, or alginate dressings. Wounds with little fluid can be managed with hydrogel, hydrocolloid, or film dressings. A hydrogel on a heavily draining wound and an alginate on a dry one are both wrong, and they are wrong in opposite directions. The same property that makes a dressing right for one wound makes it wrong for another.
Other findings are matched the same way. Dryness can be addressed with a hydrogel. Local infection may call for an antimicrobial dressing, though antibiotics should be considered if there are signs of infection spreading through the body. Deep wounds call for negative pressure therapy or packing rather than a dressing laid on top.
For pressure sores, the same idea in plain terms: depending on the size and stage of the sore, you may use a film, gauze, gel, foam or another type, and you should talk with your provider about which to use.
So the honest answer is that the best dressing is the one chosen for your wound by someone who has looked at it. If nobody has explained why yours was chosen, that is a reasonable thing to ask.