Supercharged and turbocharged engines tend to have lower compression ratio and thus need lower octane.
You are confusing static compression ratio with dynamic compression ratio and, in so doing, have gotten it completely arse-backwards.
While there are some forced induction vehicles that are tuned for 87 octane or that can pull back the boost and retard the ignition timing sufficiently to compensate for lower octane, the vast majority of forced induction designs require premium fuel to make full power.
This is because the true driver for octane requirements is cylinder pressures (among many other smaller ancillary issues, but I'm simplifying for convenience), not static compression ratio. Static compression ratio is simply a convenient rough approximation of cylinder pressures when dealing with naturally aspirated engines. You cannot use static compression ratio alone when dealing with a forced induction engine.
To give you an example, let's take a hypothetical vehicle with a low 8:1 static compression ratio and a relatively modest 7.5 PSI of boost. Air entering the cylinder is already compressed at an effective compression ratio of about 1.4:1 (due to the combined gas law, the relationship of compression ratio to pressure ratio is non-linear, so while the pressure ratio is effectively 1.5:1, the compression ratio is slightly lower). When that pre-existing compression ratio is combined with the engine's static compression ratio of 8:1 you end up with an overall effective compression ratio of a bit over 11:1.
87 octane E0 will provide less power than 87 octane E10.
No. 87 octane E0 and 87 octane E10 will produce the same power. To compensate for the higher octane of ethanol, the refinery simply uses lower octane base fuel to get back to an overall 87 octane rating.
It does bear noting, however, that the stickers on the pump are the minimum octane rating; a station could sell 93 octane from a pump labeled 87 octane with no legal consequences. So if, instead of reducing the octane rating of the base stock they simply added 10% ethanol to 87 octane regular gasoline and sold the resulting mixture as "87 octane E10", then you would get (very slightly) more power from the E10 (assuming, of course, that the ECU had the appropriate maps for it) because the E10 would actually be 88.2 octane despite the label on the pump.
But, E0 will provide better mpg.
Yes, due to the lower energy density of ethanol.
ZV