Sorry I forgot to post this here earlier got so caught up with other threads and things:
http://www.internettablettalk.com/wi...de_and_OS_2008
I created a Wiki Entry for this topic. The entry describes how to use the package that I threw together based on the information and resources everyone had in this thread to get things up and going for your "plug and play" audience.
Download the package and install it. It sets the tablet up to autoload all of the supported USB networking modules on boot, and establishes some udev rules so that when you plug in a rtl-based adapter the DUMMY/WIRED account will dynamically be created, if up will be called, and things will just work; when you're done and you remove the adapter the dummy account goes away again and the wifi will operate normally. There's a slight glitch on the removal in that if you take the tablet out of host mode without unplugging the adapter first it may not work properly, but I'm working on fixing that one.

Thanks,
-Rob