This is very easy to overlook because the attribute is extremely poorly named and missing from MCMP definition  completely. This is because mod_cluster aligned nomenclature with httpd mod_proxy's  which defines maxattempts as:
Maximum number of failover attempts before giving up.
and not total number attempts. This means, that value od 0 is a valid value meaning no retry.