##Backgroud
The Nerve Theorem (see nLab;) asserts that given a finite collection $\cal K$ of compact sets with the property that all non empty intersections of sets in the family are homotopically trivial, then the union $X$ of the sets in the family is homotopically equivalent to the nerve $N({\cal K})$. Here the nerve of the family is the abstract simplicial complex that records the intersection pattern so if ${\cal K}=\{K_1,K_2\dots,K_n\}$ then $N({\cal K})=\{S \subset \{1,2,\dots,n\}: \cap\{K_i : i \in S\} \ne \emptyset$. The nerve theorem is attributed to Borsuk and Leray (and others). There are various variations. For example if you require that all non empty intersections are homologically trivial then the homology groups of the nerve are the same as those of $X$.
##The desired extension
Suppose that all non empty intersections of sets in $\cal K$ are homotopically equivalent to a single space $Z$. Under what conditions can you conclude that $X$ is homologically the same as the product of Z and the nerve.
This is usually not the case, so the question is to find conditions (as simple as possible) that will imply it.
Perhaps the kind of condition you would need is about sets in K intersecting "nicely". For example, we can define two sets A and B as "nicely intersecting" if the usual long exact Meyer-Vietoris sequence splits into short exact sequences. So you can require that every intersection of some sets in $\cal K$ intersect "nicely" every intersection of some other sets in $\cal K$. I don't have reason to believe that this is the definition required for the conclusion but it just illustrates what type of conditions are possible.
A possible application is indicated in this question.
Edit: Oscar Randal-Williams' answer shows that my suggestion for "nice" intersection is not sufficient for the desired conclusion. Perhaps the most interesting question in view of Oscar's result is this.
Suppose that you have a family $\cal > K$ of compact subsets of $R^d$ so that all non empty intersections of members of $\cal K$ are homotopically equivalent to to the same space $Z$ and every intersection of some sets in $\cal K$ intersect "nicely" every intersection of some other sets in $\cal K$, where "nice intersection" means that the Meyer-Vietoris long exact sequence splits. Is it true that the nerve of $\cal K$ has vanishing $i$th homology groups for $i>d$?
I think that a positive answer would suffice for the Helly-type application.