Pity about the cancellation but unfortunately it really no longer has a role. As seen in Iraq, stealth technology is no good when the enemy have no usable radar and simply wait until the helo appears, then shoot at it. On the positive side I doubt if the technology will be wasted.
UAVs are the future anyway. The reckoning is that the next generation of fighter will be unmanned. I daresay the next generation of Observation helicopters will be unmanned too and indeed attack helicopters.
The Comanche unfortunately took so long in development that is simply became obsolete. As will pilots and aircrew in due course.