I think the key question here is 'what would you listen to on the turntable?', rather than 'can it sound good?'
The answer to the second question is yes, provided you choose a good turntable and set it up well. Would you get an improvement in sound quality vs. a good digital streaming source, properly set up? IMHO, no, but to some extent 'sound quality' is subjective.