there is so much room for variation and such a wide topic. i love ableton live as daw/sampler. been a user since ver 3 or 4. i don’t think it has the best native samples or available from maker sample packs but you can easily drag and drop files and i love the superduper ease of simpler and impulse itb machines. i find it very intuitive as a total program. far expanded with max4live. i think it is great and sounds as good as you can make it. i like to make my own samples, often via microsampling myself sometimes discarded tracks yield helpful stuff to bring into tracks im feeling more.

as for comprehensive, i’ve not ever found anything in music to be comprehensive. no instrument will cover all bases, especially if it is a strong instrument unto itself. it will have a ton of limitations and those will likely be the things that make it so useful.

ive never quite liked working with others daws but i have been digging into ableton live for so long that i just don’t care to even worry about other fundamental starting block softwares. i believe most daws should be quite suitable to the purposes sought, so whatever seems to tick your box, go for that and just dig dig dig dig dig!

ymmv