I think they are good when you can both skip them and do them later. Usually you can skip them but rarely can I find a way to restart it once I’ve decided I want to commit the energy to learn the app.
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