Step 2: open app, see your stupid tour, close it
Step 3: click around, realize this might be what I’m looking for but more complex than I realized
Step 4: look for that maybe-not-so-stupid tour again, realize there’s no way to restart it
It’s not all that different than opening up a piece of assembly-needed furniture that arrives in the mail. Usually I look to see it I can build it intuitively before I go to the instruction manual
It's only annoying when it's pointing out the obvious.
No, I find them annoying every single time.
Also maybe keep the menu structure logical so that users can actually discover functionality by looking through the menu, like we did in the old days before semantically relevant text was replaced with tastefully ambiguous generic pastel icons.
There isn't a fine line between helpful and hostile, there's a big honking obvious one with flashing lights and sirens on it.
So if you want to jump in right away, you can. But if you go "What does THAT button do? What is THIS menu for?" it's great. It goes more at the users pace rather than bombarding them with info.
Also note that most product managers love them.
Quite often they are a symptom of a UI that isn't descriptive to particularly discoverable.