Tom,
I suspect with this thread and the AIA/ASGCA threads, you have something specific in mind. If its your question regarding the "pulblic interest" the only conflicts I can see are mentioned by John MacMillan, whereby an owner tells you to avoid environmental, ADA, or generally recognized safety regulations regarding adjacent land uses. Then, you have a tough call. If a kid gets killed by a stray ball, I wouldn't feel any better by having a letter in the file protesting the owner forcing me to put the houses to close.
You seem to hint that even the quality of design, perhaps restoration versus renovation, or designing a certain style may be in the public interest. I don't think so. While it would have certainly been a waste to put a pitch and putt on a site like Bandon Dunes, it would be the owners perogative, no one elses. If the architect couldn't talk him out of it, then he should do the course the owner wants, or not, but who else would determine the "right" thing to do on the owners property?
I think all architects face the dilemma of underbudgeted courses at some points in their career. That is not an ethical dilemma, per se, and even business success is not in the realm of golf architecture. I don't do feasibility studies that claim a course should be built. I recommend they get an independent one.
I have looked around the office, but haven't found the ASGCA code of conduct to post for you. As Mike says, it is pretty simple, and stuff you should do anyway, like not speak ill of other professionals, especially because you don't know what difficulties he faced and how they shaped the design, not going after a project anohter designer has under contract, representing an owners interests (ie no under the table deals with suppliers or contractors that benefit you w/o telling the owner) and following applicable laws, and doing your best effort to create a technically competent and pleasing project, which is obviously a grey area to decide, etc.
BTW, the GCSAA has similar guidelines to what Tony alludes to, where a super cannot go on site and offer an opinion to an owner w/o the existing supers consent. And I know some supers who have been called on the carpet for doing just that to pick up $500 consulting fees. Its just being treated as you want to be treated.