How to edit a split vertex normal without affecting others?
In hindsight, it all comes down to order, you need to:


Set hard edges + Auto Smooth before Data Transfer modifier.
After transferring the normals, apply Edge Split modifier (to hard edges only)
Then select the faces with incorrect normals and set their vertex normal to face, since vertices are split properly, it won't affect other existing normals.