Bevel unexpected result
One of your face is reversed, you need to recalculate the normals (in Edit mode, select all and ctrlN).

I guess it messed up with the bevel because bevel uses the orientation to create the bevel profile, so two faces with opposite normal orientation > bug.

Anyway, here is a way to do it: