Smoothing two objects together without boolean
If you really want to avoid actually connecting the two meshes, you can use this custom shader by the community:

Shader: Rounded edge between the two intersecting faces?

Although best practice (and what you see in your reference) would be to just connect them with a boolean or similar operation and clean up the mesh afterwards.