I think there are good technical reasons for preferring one particular mode in certain situations, depending on how easily certain concepts are expressed. For me, the main intuition since 1965 was based on the diagram
(source)
and the idea that the big square should be the composition of all the little squares. This I termed "algebraic inverses to subdivision". Subdivision is an important tool in mathematics for local-to-global problems, which are themselves an important range of problems in mathematics and its applications. I found that Ehresmann's notion of double category, or groupoid, was very suited to express this notion, and was easy to generalise to higher dimensions. This led to proofs of what we now call Higher Homotopy Seifert-van Kampen Theorems, and for which the globular notions were not of any help.
The notion of strict higher cubical category or groupoid is also useful for formulating and proving monoidal closed structures, due to the rule $I^m \times I^n \cong I^{m+n}$, see the final section of this paper in Advances of mathematics, 170 (2002) 71--118..
The paper Ellis, G.~J. and Steiner, R., Higher-dimensional crossed modules and the homotopy groups
of $(n+1)$-ads. J. Pure Appl. Algebra 46 (1987) 117--136, relates certain $(n+1)$-fold groupoids, i.e. those in which one structure is a group, to a fascinating structure called crossed $n$-cube of groups, and which is closely related to classical ideas in the homotopy theory of $n$-ads, see particularly Theorems 3.7,3.8, which have not been obtained by other methods.
On the other hand, to discuss the notion of commuting cube in a strict cubical category with connections, the relation with the globular case was crucial, see this paper by Higgins.
The notions of the globular, simplicial, or cubical sites have been well studied. I am not sure that globular sets are very convenient. What seems not to have been well studied, or even studied, is the underlying geometric site for $n$-fold categories, since it is the geometry of cubes in which all the directions are distinct, so the direction $i$ faces of a cube are distinct from the direction $j$ faces if $i \ne j$.
Also weak cubical categories do not seem much studied, though the classical example is the cubical singular complex of a space.