It has not been done in earnest in Vancouver. There's a 15 point 'one time' fee but it likely should be more, and/or an ongoing assessment i.e. higher annual taxes. Moreover, Canada gives away citizenship like candy and families have their kids live there.
AirBnB is still running strong as well, which should be much more heavily taxed.
The government still keeps track of the amount of foreign buyers. It has plunged. It's likely that if it was a still a problem people would be doing something more but it's marginal at this point.
The biggest impacts have already happened. We had developers building hyper luxury condos explicitly marketed to an asian audience and overnight with the foreign buyer tax everyone stopped making those and the same developers have pivoted to building purpose built rental for locals.
AirBnB is still running strong as well, which should be much more heavily taxed.