A modern powerful MCU should be able to do both due to advanced power saving modes. Or youcan even have a power MCU and very low power standby MCU.

This is correct. There are a number of excellent asymmetric multicore MCU platforms now. You don't have to choose between efficiency and performance today.