It's visually satisfying for the "games-as-lovely-dioramas" impulse, but seems that it would be irksome for the "games-as-playable-games" impulse. Having these small units sort of limits your tactical flexibility if you're playing small-scale skirmish games, and having troops based like that would be a royal pain when you're advancing or wheeling an entire unit.
Still, bases, especially really thick ones that never seem to match the terrain, cause me the most visual dissonance when I look at game pictures. And they make cars and doors look strangely low.