Is a single family home with detached guest unit considered multi family?

No. A multi-family dwelling is comprised of multiple units in the same building intended to be occupied by separate family units. Someone who owned a unit comprised of 6 rented apartments would own a multi-family dwelling.

The example you gave would still be an SFR (single family residence)