It's a look that has the potential to help the dynamics of a room. It switches things up by breaking up the grid that it often formed by your sofa, chair and coffee table and will add a little visual and spacial interest through the difference in height and sometimes even the color of the two tables.
It's a trend that has a practical side too - anytime something becomes modular, it broadens the ways that you can use it, the spaces it can fit in and, most likely, the length of time the piece is useful. Down the road, you may end up splitting up the twins for a new look, but that is ok - if you like the basic design of the table, it's likely you'll find use for them as solo pieces as well.
Included here are also some single tables that mimic the twin table look (photos 9 & 10); they have multiple height surfaces attached to one base.
What do you think of the twin table trend?
Shown above, top row, left to right:
1. Miniforms
2. RS Intense Living Furniture
3. Bosa
4. Bosa
5. Villa Home
Bottom row, left to right:
6. Vibieffe
7. Arketipo
8. Kita's
9. Cinna/Ligne Roset
10. Arketipo
Images: Janel Laban
Weekend DIYs: 10 Wood Molding Projects for the Home
Monica & Austin's Charming Bungalow
Good Food to Share 
The Big Book of Small, Cool Spaces 
Apartment Therapy Presents 
The Eight-Step Home Cure 
Ercol Bar Stool
Why I Became a 1-Gallon Homebrewer
True Greek Recipe: Paximadi Bread Salad with Tomatoes, Feta and Capers
I think it's an interesting look, but I don't know that I really like it. Nesting tables are cool for small spaces though (not that these examples are nesting).
IMO, it complicates the functionality of a table. I think it's an interesting look, but it makes it much more difficult for people to gather at the same level (especially if they're sitting on the floor or are sharing food).
That tall table looks rather unstable/fragile.
CB2 has something similar... I think it's actually 3 little tables.
I like the general concept of two tables of different heights.
Not so big on these particular examples, though.
Not really convinced by these examples, I'd rather prefer nesting tables for their space saving functionality.
I like the vibieff, but mostly because it is that purple, which is a glorious purple, and ppl should use it more often (can it be the trendy color for 2012?) But I guess I like the rs intense living furniture the most. The arkeptico is sort of cute but kind of fussy.
Of all the combinations, I really love the Miniforms. I love the idea of a larger low table and smaller higher table. Maybe its just that I have a relatively low and deep sofa that makes end tables look awkward. I would really like to have a small table to pull up for my mug/laptop without losing the coffee table.
The Vibieffe is a great concept (though I feel like the upholstered one should be smaller to contrast the larger table).