I wrote this a little over a week ago:
If I could either navigate a somewhat complex menu with a touchpad or do the same thing with an analog stick, I'd rather use a touchpad. Analog control of a cursor never feels very good.
But I can do better than that. Ever play Skyrim? Imagine the touch pad acting as another button, and when pressed it brings up the in-game map. Now imagine that you can scroll around that map just by moving your finger. In an instant, you can scroll from Solitude to Riften. Start by touching the upper-right corner of the touchpad, and when you open the map you'll be looking at the area around Winterhold. Start by touching the left-center of the touchpad and you'll immediately jump to the area around Markarth.
If this can be done, then it follows that the pad could be used for additional commands that otherwise might not fit on the controller. Imagine the touchpad divided into four, six, or eight "buttons" for somewhat common, but less frequent commands.
So yeah, I'm sure people are going to use it for plenty of stupid "wipe the dust off this coffin, so you can see what's written underneath" gimmicky crap like that, but I hope you also see how smart developers could--and likely will--end up doing a lot more with it.
And today, I saw this.
I don't think people fully appreciate how many additional controller functions developers will be able to map to this thing.