books about getting what you want and feeling empty

fantasy books, like this article about Buzz Aldrin falling into alcoholism because:

"I wanted to resume my duties, but there were no duties to resume," he wrote in Magnificent Desolation. "There was no goal, no sense of calling, no project worth pouring myself into."

Just like, the main character having a Franz Kafka style realization about his life's goals.