Comprehensive search for dark matter annihilation in dwarf galaxies