Is the name brand Depends the best adult diaper or are there some generic, cheaper, but good alternatives?

I've been responsible for getting briefs for my aunt and my mother. I have been using Carewell because of the convenience. My mom is bedridden and we buy the ones with tabs. My aunt gets around pretty well and she uses the pull-ups. The overnight type would probably be the least likely to leak.

My advice if you can't get samples is to buy small packages and keep trying till you find what you like

I got Depends for my Husband. When he was on Hospice the ones provided were from McKesson. Not sure who manufactures those for them.
Both the name brand and the McKesson ones leaked. (and we had the pull up ones as well as the tab ones. )
I changed them every 2 hours, more often if he was wet between.
But I just figured they all leak at some point it is not a matter of IF but WHEN and in my Husbands case how much!
They are disposable and are not intended to be put on in the morning and removed at night, another one put on and removed in the morning. Just like an infant a change is often necessary at some point at night and several times during the day.

It truly is a matter of personal choice. My DH aunt used Depends and Poise pads. My mom didn’t like them. She preferred Sam’s Club brand. She couldn’t stand anything snug around her waist.
I noticed once at a grocery that sample packs were available. You might check into those.
When aunt went on hospice her pull-ups were provided. I was skeptical that they would work for her but they have been just fine.