There's the episode where he takes over the ship (hardcoded command from Dr. Soong) which really highlights how powerful he is.

Lore was always more fun.

My favorite Lore moments:

• [pretending to be Data] Often Wrong's got a broken heart - Can't even tell his boys apart.
• Back off, or I'll turn your little man into a torch. I promise him exquisite pain unless you obey me too, brother."

Computer, establish a security code for access to all functions previously transferred to bridge.

1734-6732-1476 Charlie 3278-9777-643 Tango 732 Victor 731 1788-8732-47 6789-7643-76.

Lock.

The problem is that the Federation is extremely conservative about the use of AI and human enhancement, so once you drop in someone like Data and allow him equal rights, there's a wild power mismatch. So he can wreck havoc if he goes rogue.

Data would never be able to pull off the shenanigans he did on Brothers against a Culture craft. Even if he's not going up against a Mind but "only" the humanoid crew, he wouldn't have such a crazy advantage.

Just look at Lore. He wiped out a colony, and could do far worse damage if he was both more competent and stable. It eventually escalated to the point where Data had to shut him down, due to the danger he posed to the rest of the Federation.

I heard that in Milton's voice from Office Space.

Data is the Pitt Bull of the Enterprise. When he’s protecting the crew he’s amazing, but watch out if he snaps.

This is why, despite Picard's moral objections to having pets, he doesn't dare broach the subject of Spot with Data.

Lore was always more fun.

I thought picard was crazy for questioning data in his quarters alone in clues. Especially after they confirmed something was wrong with him by catching him in a lie.