Do different offenses benefit from different style of small forwards?  Such as Flex benefiting a 3rd guard small forward compared to a "traditional" small forward?  Or a triangle maybe benefiting from a tradition small forward compared to a 3rd guard in the lineup?  Is there any that benefit from a 3rd big man?

From my opinion the SF means the most in a zone. You need a great defender no matter if you run 2-3 or 3-2. Besides zone I don't see very good big men running at the 3 in m2m or especially FCP.  As far as offense somebody told me that a high Ath, ok sp guard type with high per does real well shooting 3's at the 3. I tried it and was pleasantly surprised and successful. In flex I use guard types all the time because flex emphasizes 3's more.  Also in FP speedy guards are great.