How can I check to see if a used transmission is still good?

You can at least drop the pan and check it for any metal shavings (and check the fluid color clearness/smell). Next would be dropping the valve body so you can inspect it further. If the pan has been cleaned out, I would really think about giving it a complete checkup.