I have zipped up a collection of ClickOnce samples for your enjoyment. You may find a few of these samples interesting since they touch on some of the practical uses for ClickOnce. Here's the overview of the individual samples you'll find in the zip:

• ClickOnceContext - shows you how to detect a ClickOnce application from one that is not, along with other important states such as IsNetworkDeployed, etc.
• ClickOnceFirstRun - includes a utility for detecting first run ever versus first run since last update
• ClickOnceDataFiles - using the data directory for local user storage
• ClickOnceIsolatedStorage - using isolated storage for local user storage
• ClickOnceDeployGAC - shows you how to use a custom setup project (MSI) that deploys a GAC dependency for a ClickOnce application, as a bootstrapped MSI
• ClickOnceOnlineDetection - includes a utility for detecting when the application is deployed remotely, running as clickonce, and online
• ClickOnceMsmq - a WCF service with netMsmqBinding provides a reliable message queue to send transactions to a service even if the client is offline
• ClickOnceOnlineService - illustrates a factory pattern to use a WCF service used for connected clients, local data directory used for offline clients
• ClickOnceUtils - utilities used for several of these samples
• LocalizedFileGroups - sample illustrates a globalized application that uses download file groups to initiate download of required files in demand
• ManualCheckForUpdates - illustrates manually detecting updates

I have another sample for deploying a database script, that I am adding some things to for an upcoming conference, and will post here when I have completed the changes.

Enjoy!