I suspect most people would want the current behaviour: for a single delete to remove the photo from both.
You'd be wrong. Most people want to keep their source files on their desktop system, not their phones. Deleting files from mobile devices to save space while leaving them in iCloud where they (used to) have no impact on the device unless the user wants them to is a vastly preferable behavior.