I recently rewatched a bunch of ST:TNG to get prepared for ST:Picard season 3 so I can tell you while you're mostly right, there are a few exciting exceptions!

I recently rewatched a bunch of ST:TNG to get prepared for ST:Picard season 3 so I can tell you while you're mostly right, there are a few exciting exceptions! 1) Professor Moriarty is an AGI (generated by the ship's holodeck) who appears in these two episodes. The professor definitely takes initiative. https://en.wikipedia.org/wiki/Elementary,_Dear_Data https://en.wikipedia.org/wiki/Ship_in_a_Bottle_(Star_Trek:_The_Next_Generation) 2) The ship itself appears to procreate in this episode, locking the crew out of controls until it can complete the process. https://memory-alpha.fandom.com/wiki/Emergence_(episode)