If you're living in it, the duplex and renting out the other side often makes sense.
If you already have a residence, then it just becomes the numbers.
In some areas, SFRs make no sense, but multiplexes (duplexes, triplexes, and quads) have a nice return. In other areas, the opposite.
If it's strictly a rental, it's a numbers game.