You said; "This bizarre result suggests one of two things: either the wave is a fiction we invented to describe our uncertainty in the particle’s actual location or the wave somehow collapses upon impacting the detector." When an electron is absorbed by an atom, the electron wave function does not collapse, it is transformed into a joint wave function with the atom by processes that are well described by QM.