My experience in Texas has been similar to TexasSIGman's. I have never been asked to show the weapon, just give its location. Since I ride a motorcycle, I'm outside and on my feet when they approach but have never been disarmed. The normal response from the officer is, "Where is it?" "Okay, please keep it holstered and do not put your hands on the weapon."
Once I got pulled over for doing ~75 because my Keltec in my "trunk" had knowcked the DIP switches on my Yellow Box off (speed corrector for gearing) and I was reading ~130 to go what I thought was ~70. I tell him what happened, he says show me, I told him I've got another gun in there, he says ok, I open the trunk, point to the box, the gun is right there less than 6" from my index finger and he says, "Fix it when you get home." That was it.
That being said, I have heard from a lawyer buddy that DPS had started instructing them to disarm all CHL holders when stopped. My buddy got pulled over for a U-Turn in N. Texas (on his way home from Cali), and they proceeded to remove, unload, and check 7 handguns from his truck cab after stopping him. He said it was pretty annoying because the 1st officer (younger) had no issues when he said "Yes sir, I have 7 in the cab with me" but the older one just lost his mind. Out of the car, stand at the front, and he called in every single serial number praying to find something stolen. Whether there is something new or not in the DPS policy, I do not know. I think that as CHL becomes more common, you will see policies start to settle everywhere.
Your mileage may vary but so far, in Texas, it has not been a problem if you act like a mature adult about it and realize you are on their turf so to speak, it isn't time to have a measuring contest.