How to use bevel node without joining objects?
As long as these objects are not connected in the Edit Mode, Blender cannot understand the correct way to bevel the intersection.
Below I shared a .blend file where I connected a cylinder and a cube in the edit mode. For more understanding on how to do that, I recommend this tutorial: https://www.youtube.com/watch?v=M4F6Q6h2-ao