I totally get where the author is coming from and it's definitely not a humblebrag. The best way I can describe it is that the author feels like the character Cypher from the Matrix, who regrets taking the red pill and waking up to reality, and wished he was warned ahead of time not to do it. That's the spirit in which the author writes this.

The character gained something, which is knowledge, but lost something, which is the ability to be satisfied ever again.

Maybe another good analogy is vampirism. Yes you gain amazing powers like the ability to live forever, shapeshifting, and super strength/healing, who could complain about that? But at what cost? You can't even go outside in the sun anymore or eat garlic knots, so maybe it's not that great.