2.83: how to join cylinders and hollow out the junction
This particular issue arises in the old boolean solver.  The issue is that these shapes are exactly the same size and their points are coplanar.  The solver doesn't correctly eliminate all the faces.

2.91 introduced an exact solver that can be activated with a button in the modifier box, it is for these situations.