Renewal theory with fat-tailed distributed sojourn times: Typical versus rare