Re: Sharepoint Trigger: "When item is created or modified" goes rogue
You don't "Turn Off" a flow. It is annoying, but it doesn't work how it seems like it will work. I think it's more like you put it On Hold.
When you Turn Off the flow, any triggers that are made are waiting for the flow to be turned back on. Then when it is turned on, all of those qued triggers will run.
So if you turn off a flow, create 100 items, then turn the flow back on, it will run 100 times.
The best thing you can do if you really want to "Turn Off" the flow will be to edit the flow and insert a Terminate action.

Then you Turn Off the flow.
When you turn the flow back on, all of those things trigger and get cancelled. After that, you can go edit and remove the Terminate action so new triggers will run accordingly.