A few cards that I read about.
RBC virtual card, seems to do what I need.
Robinhood Gold Card, only in the states.
Wize, not sure if limits are available.
Context: I recently purchased a hotel stay where a merchant charged my card, refunded the amount, and them charged my card a higher amount, all in a few seconds.
Edit: I found Wise provides limits on their virtual cards. I have yet to test how this works and if the transaction is declined for Insufficient funds.
Not exactly what you want but thought worth mentioning - Cash Passport. It’s available at Canada Post locations. You can also buy single-use credit cards there. I think both require ID however so they’re not suitable for anonymous purchases.
Nice, I did not know about this. Looks very similar to Wise with a multi-currency card.