I have two profiles created for my raid frames, one for groups of 5 players or less, which are much larger and in a different spot, and a second profile for group of 10 players and above. Both are set to activate in pve and pvp so they should auto activate when appropriate.
I joined a mc raid tonight that had around 30 people in it when I joined, and it did not auto activate. I had to do it manually, and again, it did not auto activate after the raid joining a 5 player group.