Subd union with smooth trasition between meshes

For sure the results are nicest when the objects being fused have similar sized faces around where they meet. I think in some cases one might want to subdivide the coarser one first to get them closer.
Otherwise it should still give a result, just with some more stretched faces