Controversial Opinion #1: Understanding two things - one, that Producers and Directors can have very different visions and ideas about a show, and as a result narrative and purpose can fade/change with time. Two, that television and movie production is often a hurried, messy business, and that "best fit" solutions are often employed by production staff to make the said Producers and Directors happy and "get the job done". That said, Star Trek could take some notes from Star Wars (not in regards to narrative mind you) and have someone, or multiple someones, often called "staff" work on maintaining internal continuity in respect to one show or element of the franchise to another.
Controversial Opinion #2: Tossing the original pre-Federation design of the Enterprise in the rubbish bin effectively for a re-tooled, retro-esque Akira-class starship has always bugged the hell out of me. Jefferies' Declaration class XCV-330 coulda / woulda / shoulda been a wonderful storytelling setting (that of a eXperimental Carrier Vessel) set during the Romulan War. But hey, what do I know.
Controversial Opinion #3: Forgetting (or simply failing to acknowledge) Data's history in regards to Lal and Lore, or perhaps utilizing either one of them in some regard last season was a huge missed opportunity on Picard. The tie-in to "daughter" is stumbled over multiple times, and the loss of so important a character to Data, and indeed the rest of the Enterprise-D crew is not even given an appropriate acknowledgement as to her impact. Also since Brent Spiner has made it clear Data will not be coming back, I assume that goes for Lore as well. That is a huge disappointment.
Controversial Opinion #4: Destroying the Enterprise-D the first movie out for the TNG crew was a marketing mistake of epic proportions. Brand/design recognition is a thing, and the E (sorry, and with all due respect for those who are fans) doesn't evoke the emotional connection that many fans felt for the D. Ooops.