Discovery prospects of dwarf spheroidal galaxies for indirect dark matter searches