Forgot to post about the episode. It was very good. It felt like a solid hour of Star Trek, with a good adventure, an intriguing mystery, some good callbacks (hearing the old TOS door opening sound was great), and enjoyable characters. I actually liked the second half of DSC Season 1 (once it got to the mirror universe), and this was probably better then those episodes.
If the whole season keeps to this quality, it will be pretty great storywise. I've pretty much accepted that design wise the show is never going to be very good (outside of the Federation ships, which are generally great looking even if they in no way fit the time period or Prime Timeline in general), but as long as the story/characters/writing stays good this could be a very good (if flawed from a visuals standpoint) season of Star Trek in general. It feels good to be excited to see a new episode of ST again, hopefully it will keep this up.