I've seen manual X5's very coveted and sought after by people on other enthusiast forums. So resale could actually be higher to the right person.
To me the increase in power is not worth the trade off of a heavier, less cornerable 4.4
In my opinion the fun factor will be greater in the 3.0/Stick, if you can find a sport package