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.
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.