Afaik it is still the case that if the transaction is not opt in RBF, you get the cash immediately (yes, you read that right!). It was certainly true a few weeks ago, i.e. last I checked.
Most wallets I know (apart from Electrum) opt in though and don't give their user the choice to opt out.
Otherwise I *believe* it waits for only 1 conf, could be wrong on the number.
