What am I doing incorrectly with the Boolean modifier? *Video attached*
the problem is in the face orientation of your parts. Blue is ok, red is wrong.
Repair the face orientation and it will work.
you can check your (wrong) face orientation by tapping