You won't find anything really objective on this. A stiffer frame may take away from comfort. Without flex you feel every road imperfection and bump. For some people they can't take getting beat up and their muscle and tissues might fatigue a little acting to absorb shock. Other people won't notice much of anything. Of course this isn't about the extremes.

Welcome to BF!