I sometimes use the title given and then tweak it a bit, but I mostly either make up my own titles or use a theme. I've used tv episode titles, real novel titles, nature (flowers/trees/gems), colors, and poem lines before. One of my favorite writers named all his Sci-fi novels after the Star Trek books I own. Another theme I often use is song titles. For instance, with my current author couple, every novel my female sim writes is named after a Loreena McKennit or Kate Rusby song. Her husband's novels are titled after Sting songs, so there is Valparaiso, Lithium Sunset, A Thousand Years, They Dance Alone, De Do Do Do, etc.
My favorite theme, I think, was centered around proverbs/sayings: As The Crow Flies, A Bird in the Hand, A Stitch in Time, The Devil is in the Details, and A Rolling Stone Gathers.