Does hand-optimized(tm) today still play a role?

Apart from some embedded/driver related stuff, Id say you get 90% of the performance fruits just relying on the compiler?