It's pretty clear that Ceopatra's reputation and personality was pretty much demonised by the Romans but the one question I can't seem to find an answer for was ... What did the Egyptian people think of her?

I think they would like her more than her predecessors since she was the only one of her like to actually learn Egyptian and try to really rule the country.

I really can't say much about her popularity with the common peoples. But she did accomplish much.

She was extremely popular with her troops.
She supported studies at the library in Alexandria.
She influenced Caesar to change the calender.
She spoke several languages, and was the first Ptolomy to speak Egyptian.
She fought (politically) extremely hard for an independent Egypt, and, when
she realized this was not to be, planned a Greco-Roman Empire with Anthony.

We'll probably only be able to guess what more she would have done if she had lived longer.

I believe she was "liked" (or at least respected) by her subjects, as she was revered as the embodiment of Isis, a fact she made very clear to the powerful forces threatening the autonomy of Egypt during her reign. Though it is recorded that she was indeed highly adept at seduction, it is also recorded she was entirely faithful to both Ceasar and to Marc Antony, not to mention her four children (typifying the Isiac Mother nature). There are a number of well-researched biographical treatises on her - but admittedly, I haven't gotten to them... yet.

My question would be, was she closer to Claudette Colbert, or to Liz?

Blessings of She of 10,000 Names

My question would be, was she closer to Claudette Colbert, or to Liz?

lol--actually, neither. From existing portraits of her, mostly taken from coins of the time, she was not a terrible attractive woman. Most of her contemporaries mention her charm and intelligence, more than her beauty. She was the first ruler, after the Egyptians themselves, who spoke the Egyptian language, among six others that she mastered. She was very concerned with restoring Egypt to the place of supreme authority that it had once had in its past. She was very concerned with the welfare of her people. She was the patroness of the library of Alexandria, and was (we are told) extremely upset when it burned.
All in all, she seems to have been a fascinating woman!