Just my humble opinion, but I certainly hope that the Archeology Tech doesn't reveal *all* sites at once. I'd prefer them to be over time, perhaps enhanced by actual exploration with an Archaeologist Unit and/or certain late-game techs.
Also, they mention sites linked to wars & destroyed cities/camps, but why stop there? How about the site where a missionary/Prophet met his/her untimely end? In that case, maybe the player could choose to use the discovery for a Holy Site, or house the relics in a temple for extra faith (with additional effects being tied to the Founder/Follower beliefs of your religion). How about a Great Merchant or trade unit destroyed during a trade mission-aside from the 2 existing options, you might also have the option to sell the Objet d'Art at auction, for a one-time gold boost. How about the Improvements built by Great People, should they get destroyed by an invading army? Again you might have choices beyond the "Cultural Site vs Cultural Relics"-like a science boost from the ruins of an academy or a production boost from the ruins of a workshop.....that kind of thing.
Aussie.