I had the chance to work with Prince Andrew on a few occasions, and found him bright, inquisitive and cheerful. I was truly impressed that he was without airs - I have met US corporate types with 1000 times more imperiousness than he showed. He didn't seem to cater to those who fawned, quite the opposite.
Good dinner and drinks one time, with a very convivial atmosphere which he lead, good stories and conversation (some relating his personal flying miscues, always a sign of a healthy aviator, ego firmly in check).
Good fellow, I think.