DB tuning: Is Automatic Memory Management a feature one should use?

It makes DB Admin easier, but does have limitations. Probably best to use it only on lower end systems.