[grues-dinner]

Unlikely, since you can quite happily buy two-prong power supplies.

And most packaged modules don't even have ground connections, e.g. https://www.tracopower.com/sites/default/files/products/data...

You're also confusing the Y designation, which relates to the capacitor properties, to the application. Not all Y capacitors are used for line-to-ground applications. However any application where a failure to a closed state would result in a shock hazard must use Y-rated capacitors.