I think the ultimate expansions are not entirely unreasonable if you play multiple characters heavily- the various per character tomes are probably worth it if you actually seriously play multiple characters and would want to put tomes on them. But that assumes you care about tomes and play multiple characters.
The value proposition for single character players is not particularly great, nor is it worth it if you only play alts casually and don't care about having them maxed out. The exception is if you're in love with the cosmetics, really need the account/character storage because your bank is full and you don't have a cheaper way to get it, or want the hireling from the expansion. Unless you have some combination of the above, the value is probably pretty limited.
I actually think the worst value breakpoint is between the standard and the collectors' edition. Beyond the cosmetics, it's just a bit of storage, the heroic hireling, and a character slot. Heroic hirelings are, in my opinion, more valuable than legendary hirelings just because they tend to die a bit slower. However, if you don't use hirelings that's essentially a point value of 1620 with some cosmetics thrown in. All of that is account level stuff, so the value is one and done compared to something like tomes. I also don't think character slots are worth that much, but if you're an altaholic they may be so I'm going to be nice and count it at full value.
On the other hand, +1 Universal Enhancement Tomes run 3495 points a pop, and having one on each character increases that value (though to be fair I wouldn't count it as a full 3495 on each because I would never by a tome for that price on an alt). The iconic is also 1395 points. Character storage is 595 points. The bag is... bound to character so I'm not going to count it because I'm petty. And another character slot, of course, for 625. That brings us to 6120 before any value you add for alts using the tomes as well.
That makes it a roughly $50 difference for a 6120 point value, as opposed to a $40 difference for a roughly 1620 point value (not counting cosmetics and hirelings). If I actually tome'd up all my alts I play somewhat regularly, I would be spending around 10485 at the inflated AP tome price for the new expansion's tome, and that's not counting the alts I play just to test builds or occasionally run something when my main or other alts are at the wrong level. Both are probably still not "worth" the cost in points to buy features piecemeal, especially on sale.
I think the base expansion is worth it- $40 for 4590 points worth of value is reasonable, more or less, and while expansion's adventure packs do go on sale I would generally say I don't mind paying full price given how much I've actually liked the recent content in DDO (for the most part, ignoring rare loot and specific annoying quests). However, 1620 points is a terrible deal for $40 and 7730 points worth of stuff for $90 isn't great either and all of that is before sales discounting those numbers- though the account storage, character storage, and character slots *are* exclusive to the bundle so they can't really go on sale if you don't have any more options to buy outside the expansion. But if the cosmetics and hirelings exclusive to the expansion (or you can't get more storage and slots from the store without buying an expansion), well, I think you can make the argument that the expansion is worth it, and I certainly can't fault you personally. I'm a sucker for Flumphs, and once they had me hooked the sunk cost falacy demands I waste more money.
No one said I was smart. I can do the math to some degree of accuracy (I look forward to finding out I counted something wrong) but not the critical thinking.
Of course all of this assumes that you believe that the price in points is reasonable, or that you're buying points inefficiently, to justify the comparative prices. If you don't think any of the items in the expansion are worth the prices they'll be listed at in the store, then I think you're safe to skip the expansion entirely as you are with any expansion. But value is relative, so reasonable and unreasonable probably devolve into speculation at some point.