I do not want to blindly replace or remove quotes, this could have unintended consequences depending on the actual CSV content.So far I have found no way to specify that the CSV file (an export from another system I have no control over) uses single quotes. Now, there is an option for specifying the delemiter, but anything more requires opening PowerQuery to tweak from there (quote handling, encoding, headers, column type, etc).
Before the change, when importing from Text/CSV the wizard would have an option for the delimiter and the quote character. My company recently upgraded from Excel 2016 to Microsoft 365.
