"Modern Trek" seems to mean 2017-Present, and Star Trek that Gatekeepers seem to be happy with is TOS through ENT.
I tend to count the Abrams films as part of the modern incarnation of the franchise, due largely to Kurtzman's involvement and a lot of design cues coming from those films.
In fact, I don't think it's very productive to divide Trek into 'bad' and 'good' trek at all.
Trek has been more bad than good since the beginning. I tend to think of Fry from Futurama's analysis of TOS: 79 episodes, about thirty good ones. That ratio seems to have largely stuck for the vast majority of the franchise.
Casino Royale was good because it dumped the corny hokiness of old Bond
Which is where I got off the Bond train. The corny hokiness was part of its appeal for me. If I want the "real world" all I have to do is look outside.