As I was thinking about how fun it would be to have a job where you solve puzzles in the world, it struct me that media never depicts archeology in a real light. My short search seemed to confirm my thoughts. Most ancient sites are not guarded by elaborate traps or secret riddles to get in. From what I’ve found there were some crossbows here and there. Some rare hidden rooms with a lot treasure, but again, no traps.


What do you mean “media”? As in movies?
What you’re describing about “getting in” to places and “treasure” is a little old school. In the before times archaeology wasn’t really a thing and “antiquarians” looted old temples and tombs and sites. Their objective was to take objects which had some value.
Archaeology’s primary motivation is to learn about places, the time they were active, and the people that were active in them. Obviously finding some beautiful object or treasure is exciting, but it’s so exceedingly rare that it’s not really a consideration.
I quite like watching time team. They have a great youtube channel now but it was a BBS series for many years. I feel like this is probably about as real a depiction of “archaeology” as you’re going to get. They brush dirt away with a tiny paint brush for days and get excited when they find a tiny shard of pottery because it confirms that people were active at the site in say, the 1300s instead of the 1600s as previously thought.
In the current era, archaeologists acknowledge that accessing ancient burials and similar sites is so destructive that there are instances where we know their probably is treasure and other wonders but decide to leave it. The most famous example is The Mausoleum of Qin Shi, protected by the Terracotta army. There are other similar examples.
Movies, TV, comics, Video Games, books, etc. People in this thread have already named a few. But as you point out, archeology in reality is rarely what we see in mainstream entertainment.
Ah the Terracotta army was used in one of The Mummy movies.