Transmigrated Into My Favorite Novel as a Nobody

In a world where espers and guides exist. Our MC is an SSS-class esper who is obsessed with reading a particular book called, ‘the hero of doomsday’. Our MC dies after an SSS-class rift opens and invades the earth. He defeated all the monsters but with the over use of his powers and no guide to help him he goes insane and was purged by the association. But little did he know his story doesn’t end here. He was transmigrated to the very novel he was so obsessed with! What will Happen to our MC and what will he do to escape his eminent death?