You asked

what did ancient israelites imagine sheol to be like, beyond simply a place of death?

Reading with you…