To me, the answer to this question lies mostly in what kind of game do you want to play? I suspect some things about the offenses, based on RL and on things I've picked up here and there in the forum and the FAQ/player's guide. Here are my assumptions.
1. Flex, motion, and triangle are mostly the same, and differ only in small operational matters. In general, good offensive players are good regardless of set, given high enough IQ.
2. Players who have relatively good SPD, PER, and BH are going to tend to be better 3 point shooters than players who are average or below in those categories.
3. Players who have relatively good ATH and LP are going to be better inside scorers.
4. Players who have relatively good pass ratings will positively impact their teammates efficiency.
5. The offensive sets may differ slightly in how they operate at peak efficiency, but in general you always want at least one scorer and one secondary option. My own suspicion is that flex can operate on one primary scorer (preferably a guard) and one second option; motion operates best with at least one LP scorer, one PER scorer, and a third option; and triangle operates best with 3 shooters (inside or out), and emphasizes passing over ball handling to get open shots.
6. In general, passing is more important at PG, least important at C, with a sliding scale of importance in between them. That doesn't always mean your PG has to be your best passer, but that's generally where I've tended to notice more impact, in terms of team FG% and turnover rates.
I know that doesn't really answer your question. Sorry.