I'd think that a base like the one Scotty was exiled to in Star Trek 09 would be pretty bad. Not only was itout in a frozen wasteland, but it was pretty damn lonely there, too.
Best would be largely based on what the individual would want. I'd fantasize about a duty such as a training position which would include about half the time on Earth at the academy, and the other half in space on a training mission. The best of both. However, there has never been a canon position like this shown, to my knowledge.