I love all the other tilesets, but can't stand the dwemer stuff. It's just too steampunkish, which breaks skyrim's otherwise rather medieval look. I actually avoid going into them whenever possible. Thankfully they're not very numerous.
Actually...the Dwemer ruins in Skyrim are significantly less steampunkish than the ones in Morrowind, at least IMHO. They use a lot more stonework, whereas the ones in Morrowind were http://media.moddb.com/images/mods/1/17/16542/Dwemer_Ruin_3.jpg, particularly on the interiors--I remember being surprised that pretty much
everything was made of metal in the MW ruins. Even barrels, tables and bedframes. Most of the stonework was on the (still very recognizable and steampunky) http://neon.chem.bg.ac.rs/morrowind/atlas/bthanchend/outside.jpg.
I actually like the look of the Morrowind ones a lot better than I do the Skyrim ones. They blend into the rest of Skyrim's environment too well, as opposed to being completely alien like the Morrowind ones. (Which is very fitting, if you know the lore behind the Dwemer. They basically rejected all the "quaint" Dunmer notions in favor of science and their "gods" of Logic and Reason. Yeah, they're steampunk, but there's a lore reason behind it. They were miles and miles ahead of all the other races in terms of techno-wizardry when they disappeared.)