Where has the adoption of ranked choice with single member districts resulted in a switch from a two-party system to a multiparty one?
It hasn't happened anywhere in the US as far as I know, despite being adopted by various local governments.
Ranked choice's major benefit is that it reduces the effect of spoilers. Third parties are the spoilers.
When the national elections are still two party local, and the two big parties have any interest in the local election, those two parties will win local as well because they have some much more mind share. Many people decide who to vote for in the national election and then vote the same party all down the ballot without knowing what any of the other players stand for, thus giving the major parties a big advantage when one of those down ballot races is a different system. If you are not the big party in those other systems you still have a harder time because people don't understand how the local system is different.