Some standardization in terms of configuration is OK, but you're totally right that you don't want a bunch of "clever" configuration done by a RPM or OS level package. I haven't come across many "clever" RPMs in my time though. :) Mostly I think OS packagers are doing a good job.