We are staying in the Aruba section of Caribbean Beach right now, and that area is literally right next to the Riviera station, which is the closest station to Epcot. To get to Hollywood Studios, you would board at the Riviera station and then change over at the main Caribbean Beach station (the central hub for the whole Skyliner operation).
If you want to be closer to the main Caribbean Beach Skyliner hub (which is a straight shot to Hollywood Studios), the Jamaica section (area closest to the main resort entrance) is the closest section.
The other three areas (Martinique and Barbados -- the two closest to the main resort area/pools/restaurants -- and Trinidad) are all across the lake from the two Skyliner stations.
I don't know how to link a map photo, but if you Google "Disney's Caribbean Beach map" you can see the layout.
I have no idea which section the "preferred" rooms are located in, but I'd guess they're in the Martinique or Barbados areas closest to the main resort activities (but that's just my guess).