Sharpness of Second Moment Criteria for Branching and Tree-Indexed Processes