His books are great, but his personal life was horrible.
「彼の作品は素晴らしいけど私生活は酷かった」は英語で「His books are wonderful, but his personal life was terrible.」という表現が良いと思います。
作品ーA work(Book・Film・Performance)
素晴らしいーWonderful・Magnificent
私生活ーPrivate life・One's personal life
酷いーHorrible・Terrible・Miserable