Depends on the car. Most ICE automatics will creep forward, EVs will sit there until you hit the accelerator, manual ICE cars (especially diesels) can be held on the clutch just under the 'biting point' which will stop the vehicle moving backwards.

EVs will sit there until you hit the accelerator,

Some do, some don't. Most I've driven try to replicate the bug in ICE automatics that causes the car to creep when your foot's not on the brake.

manual ICE cars (especially diesels) can be held on the clutch just under the 'biting point'

I, too, love the smell of burning clutch plates. Use the brake, that's what it's there for.