I would like more than one opinion.
Who needs opinions when you can have math?
Power figures at the wall will be higher than whats stated for the chip but lets assume the stated power figures apply at the wall with an electricity price of $0.25/KWH.
Assume BTC exchange rate of $150
Once difficulty reaches 10B, per month each chip:
in turbo mode, 40W 40GH, it will mine $9.17 and cost $7.2 in electricity -> $1.97 profit
in normal mode, 15W 25GH it will mine $5.73 and cost $2.7 in electricity -> $3.03 profit
Once difficulty reaches 20B in turbo mode the chip will operationally run at a loss, while in normal mode it will still be profitable.
Depending on BTC exchange rate and your electricity cost (and PSU/PCB efficiency), the point where one mode makes more sense than the other changes, but there will always be a difficulty level were turbo mode is less profitable than normal mode unless you have free electricity.
Also note that if you need to actively cool your house/datacenter, effective electricity cost could be 2-3x higher and the point where normal mode makes more financial sense could be achieved at a difficulty of only a few billion, a difficulty level we are likely to see early 2014.