As somebody who has struggled with similar issues, oftentimes the psychological help you need is to de-emphasize the ambition and success. You have to act against the expectation and dreams of greatness, and instead focus on your present state and appreciating that. It's not impossible to do great work and be happy, but it's very easy to let your dreams consume you.