Finite Temperature Physics of Molecules and Solids via Auxiliary Field Quantum Monte Carlo and Observation of p-Type Dipole-Bound States Near the Molecular Threshold