I'm up to date with the manga and

What kind of show it'll become
It doesn't become infinite power scaling like DBZ but rather his quirks generally enhance his ability to fight in a battle giving him more options...

Nature of DEKU in BNHA
...options overall that aid in battle intstead of OP offensive options, they're mostly like support quirks like...

Spoilers for the quirks explained very poorly that it's not a direct spoiler but still spoils what the quirk will be like
in order of appearance
Sero's tape but 100x better, /fly, Beta spidey sense with pain, smoke grenade, stockpiling quirk but it actually stockpiles like an independant quirk >Discount 1 time use 100% moves