I completly agree with a series about beloved characters. So why not do a post-Romulus explosion series, like a series post 2387, let's say somewhere between 2390-2400, and could show us almost every character from TNG/DS9/VOY, as main or episodic guests. We could have a star ship with a captain and 2-3 main characters selected from the previous series but the premise of the series would be something to be different enough from the previous series.
It would be doomed to failure from the moment of inception. Outside of Picard, Data and maybe Worf, the modern casts have absolutely no mainstream appeal. Outside a prequel about Picard on the Stargazer
(more action oriented format) or a straight reboot of TNG, you're likely to never see the 24th century again on screen.
The type of series you propose above wouldn't interest anyone except the 2% who already read the novels.