Yes, many pit bosses and hosts will have club passes. I've only tried getting them at Wynn, Venetian, and Bellagio (for tryst, tao, and bank respectively) and at each of those properties, the passes are considered discretionary perks. Discretionary is always nice because since the pit bosses know me, I don't even have to have played that day... just have to stop by and have them fill one out (a real plus for locals).

I have had no problem with the bouncers/vip hosts at the club letting me straight in, except at Tao because they tend to be jerks and love making people wait... and maybe one time at Bank when the doorman wasn't sure about it, but immediately called for someone else who waved me straight in. Just make sure the doorman knows that it is a gambling comp pass, and make sure you're in the right line or area so you don't have to wait unnecessarily or push past too many people. For example, at Tao, don't bother with the guest list or "VIP" lines, just go straight to the table entrance.

Also, be aware that at many properties club passes are not limited to gambling. Some of the gourmet restaurants out there will happily give out club passes to diners, on request.

Oh, I should add that I've never asked for table comps so can't comment on that.