If this were the case, by now every possible progression would probably been used to death.
Although guidelines do bring Tonal Function to a progression, how the Tonal function is processed opens the door to many opportunities.
Example; The Key of B can function differently depending on how the progression leads. The Key is shared with G#m, so the progression could function in the Key of G#m.
Another option is that the progression could function in the C# Dorian Mode.
The options go on and on.
A progression can also temporarily drift in and out of key to create some dissonance with the desired chord(s) and return with a cadence strongly outlining the Key.
A progression can modulate to another key (and back again, if desired), by introducing a Secondary Dominant for example and give the song a whole new Tonal Centre, if desired.
Etc.,...etc,....etc,......
I would say that the main rule applies to knowledge in Theory (so that possible options don't go undiscovered) and using your inner ear to hear how the options function with each other.