That depends on lots of things. Where you fly being the single most important. No point joining up with a particular airline if nearly all the places you need to go are not well served by that airline or it's partners.

Other important factors are what type of fares you buy, what you want out of a program (status benefits or cheap awards or readily available upgrades or ...), etc.