I find DS9's set the more intriguing and dynamic than TNG's Winnebago beige look.
The Next Generation looks classy and elegant. The Enterprise, especially, looks sumptuous. It's lavishly appointed and doesn't scream "high tech," the way some sci-fi shows have a tendency to do. And the "D" looks very sleek and futuristic, without being an incredibly "busy" looking CGI nightmare, as later Enterprise vessels became. My only complaint about the "D," really, was the warp core. Neon rings encased in frosted plastic blinking up ... blinking down ... oooh ... power ...!!! Hateful, "Z" ... just hateful.