I guess my question is what did they think of the Pharaohs that were buried in them, and what did they think of them in general? Also what did the Romans at the time think of them?
Remember that the Pyramids and Sphinx and other Egyptian monuments were already ancient by the time of Cleopatra VII. We are closer to Cleo's time than she was to the Pyramid's building! So they would have marveled at them much the same way we do today. The pyramids were a big tourist attraction, as were the Valley of Kings and the Talking Colossi of Memnon. Herodotus visited in the 5th Century BC and wrote about them and his travels. Even before Cleopatra VII, the Romans were heavily involved in Egypt, so it wouldn't be uncommon for Roman merchants or officials to visit the sites. Once the Romans secured the Mediterranean, tourism really took off. There are many inscriptions in Greek and Latin attesting to Romans and others visiting. Most of the inscriptions on the pyramids were lost when the bright, white limestone casing blocks were looted/repurposed, but they remain on the Sphinx and many other places. These were sometimes carved by the individual, but some were clearly carved by a professional stonecutter hired to make the graffiti. One army officer named Januarius and his daughter Januarina visited Ramses IV's tomb and left their names at least four times. The tourist industry appears to have been thriving enough to support tour guides and package tours up the Nile.
Casson, Lionel Travel in the Ancient World