Yep. It's a risk reward deal. And the gamble is why most adventurers don't do it.
Well apart from the peer pressure, he's also there specifically for the vampire card reward to rank up his ghoul to a vampire.
It was implied that he ate a demon core when he was a kid. Not to mention the rumors of his mother being a snake demon. So there's definitely something going on.
Creating and Releasing a country/world ending calamity is probably enough to destroy his family and not just himself.
Hell, it should probably involve other kingdoms attacking if not sanctioning the country for raising such a traitor to mankind.
If it came out that he's part human then he'd probably lose his rights as an Aberrant citizen. He was probably born with those bandages since they change depending on his mood.
It's A solution to a non-existent problem. His only reason behind wanting to break the level limit is pure Greed and Envy. His impure motives is what really makes it a bad idea.
And his short sighted-ness is what causes the whole situation to spiral out of control.
As I was reading this I was reminded of Tarzan and John Carter. Tropey solo romance action novels. It would be pretty funny if someone did a re-imagining of those with Harem comedy tropes.
I'm pretty sure it's been explained in the novel that it's all 100 percent coincidence that Cid 'gets it all right'. Which is also feeding into his delusion that everything is staged just for him.