The self-styled Gypsy King and his reclusive sister seemed polar opposites – but both painters were selfish, obsessive monsters, according to Judith Mackrell