It's a good game now that it is FREE TO PLAY , even the client is FREE /
I think the european version is NOT free, hence you need to get the USA version. Since it's free the population has jumped alot.
If you want something for a more casual type of play [similar to playing Guildwars] , especially if you have a 2-4 close buddies , then DDO is definitely it. It's basically a lobby [a town like in guildwars] and then jumping into dungeons from there either solo or with a group. The dungeons is also alot more detailed than a typical WoW dungeon and resembles the good old Dungeons and Dragons type of dungeon crawl as found in say Baldur's Gate with the trap finding, secret entrances etc.
The combat is very fast, almost dungeon siege clickity fast which might take awhile to get use to. It feels alot more diablo-click combat than say WoW-tab-auto-attack combat.
So as a subscription game it failed, but i'd say it's now reviving since it went free. Even guildwars you still need to buy the box , DDO you don't even need to do that. So you got -nothing- to lose here imho. If you want an MMO, without paying a single cent, this is probably one of the best F2P mmos out there......(and if you want to pay, there's definitely a few better subscription based MMOs )