This conundrum has been researched by Avraham Grossman in his monumental work on Rishonim from Ashkenaz more than 40 years ago. Attached are 2 pages from the book specifically about the Rashi connection.
A detailed treatment about R' Shimon is given in the book from page #86.
