Received my replacement flex cable today.

The good news: There's fresh adhesive on the back of the new cable.

The bad news: Looks like my N900 has more internal damage than I first thought. Needs more investigation.