Astavrides,
Your description of those holes is pretty much spot on. They are interesting, but pretty much unplayable when the wind kicks up, which occurs frequently out there. I have played #3 as a four shotter before from the back tees, especially if I've missed the fairway or if its really blowing. I actually like #4, I think its a good par 5, where the temptation to go for it is almost always there, especially if you hit a good drive. Six is a solid par 4, but that green complex really doesn't fit in with the rest of the course, and you are correct about not knowing the extreme nature of the two tiers unless you have a perfect angle, which is difficult on a 440 yard hole.
I am not overly enamored with the course, and can see why people criticize it. However, it is hardly the monstrosity that is The Ranch, and there are plenty of worse ways to spend a day. It is better than Eagle Ridge too, which I suppose isn't saying much either. To say that either one of the courses on the Coyote Creek property are among the worst in California is quite a stretch. It is, however, a good example of the mediocre, overpriced golf that is prevalent in the Bay Area.
Never did see the Senior Tour play out there when they hosted the Siebel Open. I can imagine the players probably weren't really big fans of the Tournament Course. Way to many hazards, environmental areas, and that fierce wind. I believe Hale Irwin has the course record, which I have to assume was during the event.