Battlefield 6 excels in multiplayer with classic gameplay, well-designed maps and a beautiful presentation, but does its campaign ruin things?