Of course, everyone's opinion on this will differ. However, I found all of the TV series to be pretty uninspiring to be honest. TNG (blah, by far the least visually interesting internally, externally, even down to the props!). DS9 (my favorite sequel series but the look wasn't great), VOY (best looking of the sequel series but an average show), ENT it was ok.
None of them blew me away visually. I still enjoyed many of them and it was because of the stories. I think what I've seen of Discovery visually is at least on par with the previous series in terms of design, but ultimately I'll be judging it on its ability to entertain me. Obviously the SFx are technically a higher quality because of the larger budget and technical advances since the other shows. I think the props look fantastic. Will have to see the sets and ships in action to get a real sense for what they look like onscreen. But, they won't decide my enjoyment of the show.