In season 1 and 2, Roddenberry still had a major say in the direction of the show. That is why you get all the sex storylines....Data nailing Yar, Riker hooking up with leaders of other planets, Riker getting it on with holodeck characters, the female crew members just waiting to hop into bed with Okona, other guest stars coming on board and having no shame when hitting on Troi in front of everyone else, etc. It really can be cringe worthy at times and certainly embarrassing. There are still some story lines like that in the other seasons (i.e The Price, The Host, Man of the People), but at least these shows have other redeeming qualities.
The dialogue on some of the episodes is so bad that it makes the episode nearly unwatchable. Datalore must have the absolute dialogue of any Star Trek episode ever.
The entire Wesley arc also ruins the first 2 seasons of TNG for me. Letting a 13 year old boy on the bridge is ridiculous. Could you imagine the lack of respect a new captain would have from his crew if he pulled a stunt like that? This would have been a conversation Picard would have with an officer of Starfleet as to why he/she wasn't allowed to take a regular bridge shift, "I know you graduated from the academy, spent years serving on other vessels, your service record has been exemplary, and you finally got assigned to the flagship of Starfleet, but I have instead decided to make a 13 year old boy a member of the bridge crew. By the way, I'm also trying to get lucky with his mom."
How many times can a 13 year old boy save the ship from disaster? The Naked Now, Where No One Has Gone Before, The Big Goodbye, and Datalore to name a few from the first 12 episodes.
It also seems like the flagship of Starfleet would also want a crew that had more experience than the ones assigned.
Some of the scripts were super boring, completely unbelievable, and crass. When the Bough Breaks is horrible. A planet abducts 6 children to build their future population?
Episodes like Home Soil, The Arsenal of Freedom, Haven, Lonely Among Us, etc., are just boring.
That isn't to say I hate season 1, because it does have nice moments in it even if most of the episodes are not very interesting.