Mixed adjoint-fundamental matter and applications towards SQCD and beyond