In hindsight ds9 has some issues. But I think anything after tng/ds9 are just not really star trek. You might have a interesting or decent episode here or there but it just doesnt really feel the same. Some of it may just be the mixing in more modern language, need to try and add all the zingers etc, sassy bitches for no reason etc.
Like the first new jj Abrams explosions everywhere movie kinda won me over just for a visual spectacle and just an action movie in trek clothes, but that got stale and worse writing by the second movie.