Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.
I understand that you would like to know if you could use Azure as a Transit between your OnPrem Sites.
I believe you should go ahead with Route Server for the above configuration to work.
Wrt SiteA and SiteB,
Consider, ExpressRoute Global Reach
San Francisco as SiteA, London as SiteB and 10.0.3.0/24 as Azure.
In case you want Site A and Site B to directly talk with each other, you can go ahead with ExpressRoute Global Reach
However, should you require connectivity across all the sites A,B,C,D to use Azure as Hub, I suggest you go ahead with Route Server or Virtual WAN (with Branch to Branch enabled).
Thanks,
Kapil
Please don’t forget to close the thread by clicking "Accept the answer" wherever the information provided helps you, as this can be beneficial to other community members.