I find it kind of sad they haven't done anything in the 2290s-2350s era. I think it would be fun to have a series with April in monster maroon coming up on his second retirement in the late 2310s or early 2320s.
The IDW miniseries Picard's Academy was set in this era (aligning with previous canon of when Picard went to the Academy). I enjoyed it (checked it out from my local library), though probably half just because of Spock's outfit, honestly.
EDIT: April probably wouldn't be the primary focus. It would probably focus on a diplomatic ship or maybe even the Academy or civilians. It probably couldn't be too action-based, as we don't want to undermine this being one of the most peaceful eras in Federation history - I worry to do anything interesting, you'd have to pull Disco-style shenanigans again. No matter one's opinion on Disco, I feel like it would be kind of obnoxious to do another "this secretly happened and no one knows about it" series.
Burnham falls afoul of the “no promoted mains” rule, unfortunately.