I have been watching and thinking about this thread ever since it was posted and - yes, it's my opinion only, but having moved several times during my career and having looked at a myriad of houses - and designing a few - one of the biggest drawbacks to me and my wife is wooden decks - raised or on the ground or whatever...
Especially on the ground...
Why not do a flagstone (over a sand bed), or paver brick, tiles (various kinds) or plain old concrete - stamp it or color it or whatever - but once done, never have to seal it, or worry about warp, rot, stain, varmints underneath - whatever...
Wood is so expensive nowadays - and "treated" may or may not hold up over say, 10 years or more. Various woods such as redwood and cedar are $$ out of sight if available at all to resist problems... So are the fake planks - even though they look nice...
Just my opinion... but I believe wood decks are essentially "temporary" and will personally never buy or build another wood deck - maybe only if totally covered to keep from exposure, rain, sun, etc...but then, what's the point??
Granted, if a lot of fill and even a retaining wall is required because of sloping ground, etc., it may be the only economical solution... but only as a last resort after looking at more permanent options requiring less life cycle maintenance.
I will say the best option for a second story deck off a bedroom or something might be a wood deck - but it needs a cover/roof/awning or something to protect it...
And, the best other use I have seen that makes sense to me is extending the area around an outdoor swimming pool for various reasons.