A few cards that I read about.
RBC virtual card, seems to do what I need. But it's available for business use only.
Robinhood Gold Card, only in the states.
Wise, not sure if exact limits are available.
Context: I recently purchased a hotel stay where a merchant charged my card for the advertised price on their website, the amount was then refunded. Then another merchant charged my card a higher amount (a few hundred) all in a few seconds of the original transaction.
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, does anyone have experience with this?