“Since I was a boy, I’ve dreamed about being a cop and living on the moon. But now I’m here, it seems like the party’s over and everybody’s going home.”
This is the premise of Mooncop by Tom Gauld, best known for short cartoons in places like The Guardian looking askance at genre norms (some of which I’ve linked to before).
Post-apocalypse SF and post-Golden-Age fantasy are both pretty common, but an okay future that’s a bit past the exciting frontier era not so much. Settings tend to be about the exciting bit, after all. It would be a good start for a more slice-of-life approach though.