I switched gyms when I was going from level 8 to 9. My original gym was ruled by "queen bees" and I was not one of them. I was one of the younger level 8s and the "queen bees" were most of the older level 8s and then pretty much all of the level 9s. Everything was catered to these gymnasts even if it was not the best thing for the rest of the team. Without going into detail, I'll just say it was terrible.
When I switched gyms, I moved up to level 9 and I had only one other level 9 teammate. This team was known for having decent level 8 gymnasts but they never had many successful level 9 gymnasts. However, we knew one of the coaches already and she had coached college gymnastics before and my parents and I were fairly certain she would be a good coach for me. She was and I learned a lot of new skills. I was the first person in the gym to do a lot of skills which was pretty exciting for me. Even though no one in that gym had learned any of the skills I was learning my coach had coached those skills when she was coaching college gymnastics. When I was learning them in our gym, a lot of the other coaches could follow the drills and progressions I did to get the skills and eventually learned to teach those higher level skills themselves. Even though the gym I switched to didn't really have anyone in level 9, with a good coach I was successful.
I was in high school but there were a lot of girls who were older than me so I guess they were the role models. I didn't have any role models skill wise and I think that was good for me because it was more exciting since I was the only person doing x y and z.
It really depends on the gymnast but I was definitely more motivated when I was one of the better gymnasts at the club, rather then when I had a bunch of older teammates who were the same level or higher. It really depends on the gym too but at my original gym all the supposed role models were burnt out and didn't have their passion for gymnastics anymore so even if they were good gymnasts, they weren't someone who I wanted to be like.
A gym in my area started out probably like 10 years ago exactly like that and the girls who were competing level 4 back then are level 9 now and they are pretty successful.