Can one of you knowledgable HNers tell me how I, as a dude who owns some domains and occasionally uses DNS to point them somewhere can get on board with this? Or is something that can only be implemented if you're hosting your own DNS?
In the immediacy, you should know that deploying DNSSEC isn't going to do anything for the security of your site, nor is it going to make it more reliable for computers around the world to reach your site.
You need to run your own DNS server (this is really the whole point of DNSSEC!), and setting it up is an absolute dog atm.
The ISP you're hosting your domains at needs to support this.
For ccTLDs only, there is this list : http://www.statdns.com/cctlds/