Personally, I don't think the shows need quite the production value they have currently. I think they can use some old tricks... use more stock footage for the ship. You can use the same exterior flyby more often, it's ok. Use less expensive locations/set dressing. I don't think it would kill any us to have some more planets that look like... the forests of Ontario, Canada.
There absolutely are examples of gratuitous use of CGI in pretty much every season. Things like the weird funhouse universe inside the turbolift shafts at the end of Season 3. Or a number of uselessly cluttered 3D displays which don't actually make anything clear. Some of this really does feel like busywork for the VFX team, not something that either the script or the pacing of the show really needs.