Mine is that Discovery should have been a series taking place in the Picard era.
Keiko wasn’t that bad of a character. She wasn’t a great character, but the biggest problem was that her actress, Rosalind Chao, had very poor chemistry with Colm Meaney, who in turn had great chemistry primarily with Alexander Siddig, and also with several other actors. This wasn’t a problem when she was cast in “Data’s Day” as the bride to be with nervous bride energy, if anything that’s an asset in such a short time frame. But then expecting that to work in what is supposed to be a long-term marriage is what led to perception of her being all MIIIIIILES all the time.
Now, I don’t know that mid to late 90s Star Trek producers would have been on board, but they should have written an amicable divorce plot for the O’Briens. Miles and Keiko clearly grew apart from each other over the course of the show. Between her extended trips to Bajor and the way she all but threw Miles at Kira, they were already about 85% of the way there anyway. A divorce would have been a great way to resolve that issue, and use Star Trek as it was always intended: to explore real life issues in a scifi universe.