Read manga: 31 Heroes

manga
Summary:

Rokurou, the class' cockroach (figuratively speaking), is visited at night by an alien girl who bestows magical powers upon him!
Finally, he can ascend from his status of a complete nobody to the town's unique super hero! … Right?