I have tried the virtual one once and I was able to pay for it using Lightning. There were no fees and the exchange rate USD <> BTC was exactly what my LED Bitcoin dashboard (hitbtc.com API) was displaying (negligible difference).

However, it was not accepted for an online sports channel subscription (1 month). Either they don't accept debit cards in general, or you need to load it more generously (not like me).
I do think these kinds of one-time debit cards (existed in the past even without crypto; you bought them through your actual credit card) make most sense if you can load them with just the amount needed for a purchase, so that you don't need to use them twice or have a bunch of them with $2 each on them that you can't spend.

One such example that (in a video I saw) was very well integrated was a service that came with a browser extension, which recognized payment pages. Once you landed on a shop's payment page, the extension would create a one-time card and display a Lightning invoice. Once it was paid, the card details were even entered into the website and from a user perspective, you never really 'touched' a credit card number or anything like that, but basically paid in Bitcoin directly.

As far as I know, at that point it was a video POC and it wasn't production-ready; unfortunately, I can't find it anymore either. Maybe my description sounds familiar to someone who can recall the project name.