Sci-Fi Novels where ancient technology, ships, or civilizations are discovered

Looking for that sort of Stargate Atlantis flavor of things. Do you guys having any recommendations?

Wow! This got more attention than I thought it would! Thank you so much for all of the good recommendations!!!