I'll second Rendezvous with Rama. It's an excellent book, fitting exactly with the theme. OP is looking for. The first sequel is pretty decent, but the two books in the series after that, while I liked overall, I think they lose the magic that made the original so special.

I'll also say House of Leaves is also fantastic. It's disturbing and confusing and really well written. I'd recommend picking up a physical copy if you can, because for this particular book, there's stuff done with the printing, type setting, font colors, and style that's hard to replicate on an e-reader. Top tier book!

I haven't read the others you mentioned, but they're all on my reading list.