It's very pretty, but it is also very expensive and fiddly. I was gifted a basic set of Dwarven Forge, but I quickly realized how much time, and effort, it took to assemble even a simple setup. I also quickly discovered how much more product I needed to represent more than a single, small room! I estimated I would need roughly $1,000 USD worth DF sets to come close to what I would want for my RPG games. The same is true of these products.
I also realized how much it would limit my gaming style -- I run mostly improvisational gaming in a sandbox, so the players can go anywhere, anytime, for the most part. I still use the time-proven, and oh-so-versatile, and affordable, vinyl battle mat, with colored transparency pens, a roll of Paper Towels, and a bottle of Windex. Speed, and versatility, win out, every time, in my RPG games.
Now, if I am playing a miniatures game, then the vinyl mat is gone, and 3D terrain is pulled out, but that is a different style of gaming from RPG's. For my mini's gaming terrain, I play what I can afford: home-made, inexpensively crafted terrain, built from the excellent ideas and techniques presented by genuine artists, on the Internet.
Building terrain is a hobby unto itself. I find it far more satisfying than ordering pre-made stuff off the Internet. YMMV. Cheers!