It really depends on the hole. But here are some general rules I follow on particular courses.
On Beth Page Black I use mostly back spin - but this has nothing to do with distance! It's simply easier to keep the ball on the fairway with less roll here. #2 and #11 are good examples. #1 and #16 both have severe drops in elevation off the tee. I will almost always use top spin on #16 - the fairway can accept it. But on #1 I always use backspin so I don't overdrive it into the rough.
At Kiawah - anything goes really. For me here it's mostly about shaping the shot. A lot of the holes set up for a draw. Of the tee on hole #2, #3,#4 (and sometimes #5) I am moving my marker right and hitting the meter way early to mimic a draw.
St. Andrews, yes the fairways roll out a lot, and top spin can be your best friend - or it can put you in the fescue! You simply need to consider the loft you need to get to the safest part of the fairway.
I think this drive still holds record here at 414 yards. I had just a bit of bs on that shot- wanted a little lift, but still wanted the roll. I really got a lucky bounce there! (30mph wind helped a bit too!)
Oakmont, from the back tees, Is totally a schizophrenic driving course. Lots of elevated fairways, and no matter what you do, you aren't going to get a lot of roll. So for me, I go with BS a lot of the time, more carry usually equals more yardage there. From the shorter tees, an iron off the tee is sometimes the best call.