In short, a passphrase can be used strategically for 2 purposes: protecting you against brute-force attacks on the seed phrase (of course, a weak passphrase or one consisting of only 2 or 3 words would be easily rekt) and providing plausible deniability. For the latter, it is a good idea to have "decoy wallets" containing a small amount of sats to convince an attacker that it is "all you have."
As long as the underlying entropy of a mnemonic seed phrase (the recovery words) isn't severely flawed and weakened by a defektive RNG or other stupid methods of bad entropy generation, I see no feasible way for brute-force attacks on a good entropy mnemonic seed phrase. There's not enough energy and time left to execute such an attacks on this planet or solar system we're bound to.
I see a use case for an additional mnemonic passphrase to protect a wallet from the risk that somehow the mnemonic seed phrase could become compromised, e.g. at a remote backup location which you can't control and monitor all the time.
For the "decoy wallet" with no added mnemonic passphrase I would recommend to use some "convincing" amount of coins, not just a "small amount" only. How much "convincing" might be, is at your discretion. You should also very much pay attention to have no connection of the sacrificial coins to your main stash, otherwise decoy won't quite work, the blockchain doesn't forget.
The "decoy wallet" also serves as a canary that your mnemonic recovery words have been exposed and compromised when it gets emptied by someone else than you. Therefore the need for a
convincing decoy amount which likely will be swept by an attacker.
Another nice use case is that any unique mnemonic passphrase generates a new wallet if you need more than one. You could simply append a number to your mnemonic passphrase and count up for any new wallet you need. No additional redundant backups for the recovery words and base mnemonic passphrase needed which simplifies backup needs significantly.
Sure, this upcounting doesn't add much entropy to the new wallets. I'd argue that this isn't needed when the entropy of your recovery words and your base mnemonic passphrase part are good and strong enough, that brute-force attacks on them aren't any feasible at all.
For me this is simpler than multi-sig setups which have way more redundant backup fuss.