This is a video tour (from E3 i think), of the final revised Wii U Gamepad:
It gives a good idea of all the features and potential gameplay options the pad can possibly give.
Im really glad they changed the analog sticks and have included an extra button press in each as that feature wasn't shown on the first revision.
The touchscreen doesn't have capacitive touch, which is annoying, but i don't think it'll make a huge difference for the way they are going to use it in tandem with the controls.
Im also happy they included 4 shoulder buttons, i may be wrong, but im pretty sure the first sighting of the pad only had 2, which would have been terrible for FPS.
Biggest worry is with Zelda really. With the recent leaked info, you could assume it heavily relies on the pad for most of it's new gameplay features. Problme with that would be; you lose the amazing 1-1 sword fighting from Skyward Sword...
I really wouldn't want to go back to Zelda without the 1-1 sword / equipment gameplay features, but im sure they know what their doing! ;)
Overall, im really excited to see what features it can bring to gaming, although at the same time im worried how many mini-maps will be displayed on the screen ala DS! :)
Also, if the Wii U didn't beam an info to the screen and just used the pro pad, would games have a better chance in running in 1080p? Just interested really.
All in all, i can't wait to get my hands on one and Nintendo Land especially! I think 5 player gameplay will be a great new feature and hopefully bring back some of the feeling of split screen from the N64 days!
Also, very much looking forward to Zombie U and the multiplayer where the other player uses the pad to 'direct' Zombie attacks! Sounds fun!