It entirely depends on workload. This blog has a diligent mixed-model comparison of the M3 laptops lined up against the Titan RTX (2019) and Tesla V100 (2017): https://www.mrdbourke.com/apple-m3-machine-learning-test/
I'm aiming at 64GB or more for my next Mac, but not because of AI but to ensure longevity. Macs in this house tend to have very long and productive lives.
Even if you found enough tasks where the larger memory available would make a difference to average mixed performance closer to a NVidia solution, they would seriously need to lower their RAM price for this argument to hold up...
With their current commercial offering, Apple isn't competitive for anything, even though the computers and chips themselves are not bad at all.