Is it possible to have accumulation of electron density in the inter-nuclear region even if the overlap integral is zero? Recap:
Lately, I've been studying Hückel theory where I learned about the approximation of neglecting all overlaps and making overlap matrix an identity matrix that is $S_{AB}= 0\;_; \;S_{AA}= 1$ or $S_{ij}= \delta _{ij}\;.$ He then replaced the off-diagonal Hamiltonian elements with parameter viz. $H_{AB}= \beta_{AB}\;_,$ where $\beta_{AB}$ is a negative quantity.
Question then arose if the overlap is zero as is evident from $S_{AB}$ being zero, how can there be a non-zero value of $H_{AB}$. It was known to me that $H_{AB}$ is the

contribution to the energy due to the accumulation of electron density where the two atomic orbitals overlap, including, for instance, the Coulombic attraction between the extra accumulation of electron density and both nuclei.

So, it is contradictory to simultaneously have the condition $H_{AB}\ne 0$ with $S_{AB}= 0.$
I asked this querying for the same; there I got a nice answer from Brian where he showed that even if $S_{AB}=0$; it need not be necessary to have $H_{AB}= 0$; the graphs he provided in his answer prove this otherwise a counterintuitive fact.

Present thinking &amp; associated query:
Brian's answer confirms the fact that $S_{AB}= 0$ and $H_{AB}\ne 0$ can go with each other. But doesn't that mean there is no need to have a net overlapping of AOs between the internuclear region in order to have accumulation of electron density in the internuclear region?
For example, while using Simple Hückel Theory for ethene, Atkins put all $S= 0$ as usual per the approximation and then wrote:

[...] Finally, as explained in the derivation, he also supposed that the terms $H_{AB}$ and $H_{BA} ,$ which represent the energy of the interaction of the two nuclei with the accumulation of electron density in the internuclear region .......

Really, if he writes this after considering $S_{AB}= 0\;_,$ doesn't that mean there can be accumulation of electron in the internuclear region even if the the participating AOs are orthogonal and there is no net overlapping? He is considering the case of ethene $\pi$-network which means there is electron density that leads to $\pi$-bonding even if $S=0$.
So, is it right to conclude that there can be accumulation of electron density in the internuclear region even if there is no net overlap in the atomic orbitals?
If you define overlap as given by the overlap integral, 

$
S_{ij} = \langle \psi_{i} | \psi_{j} \rangle
$

than you can have an accumulation of electron density in a specific part in space even though $S_{ij} = 0$.

Of course, if the complete wave functions of the two AOs are completely non-overlapping in all space, for instance because the centers of the two AOs are seperated by a long distance (say more than 5 A), then there can be no accumulation of electron density anywhere. This is of course logical. There is hardly any accumulation of electron density between two atoms that are quite far apart.

An interesting scenario exists where two wave functions have opposite sign and an overlap of these wave functions actually gives a decrease of electron density. This is termed deconstructive interference opposite to constructive interference when there is an accumulation of electron density.