Given that DSC was still a prequel during S1, I figured at the time that whatever happened could either be undone through time travel, wouldn't actually happen, or would be recovered from through a hand wave.
Well yeah. Same issue ENT had with the Xindi war.
I would like a bit of a lower-stakes, personal story though. Even the movies weren't all high stakes. Going through them:
TMP - Earth is in danger
TWOK - Personal story, Khan isn't that big of a danger to the wider federation.
TSFS - Personal story. Genesis device would be a bad weapon in the hands of the Klingons, but that's really the B plot.
TVH - Earth is in danger - though ironically the plot of the movie itself is much lower stakes
TFF - Low-stakes personal story (looking for god)
TUC - Stakes are keeping the Federation-Klingon peace process going. Pretty high stakes, but if Kirk failed, it would basically be the status quo. A rare movie where the heroes improve things.
GEN - Planet in danger somewhere we never heard of, so comparably low stakes
FC - High-stakes, as they need to fix the timeline to stop the Borg
INS - Low-stakes - save a few thousand NIMBY hippies on a single planet
NEM - High-stakes (Earth is in danger)
ST09 - High-stakes (Vulcan destroyed, Earth directly threatened)
STID - Stakes are...war with the Klingons? Maybe Starfleet HQ. Medium-stakes movie, not absurd levels.
BEY - A big space station we never head of.