...
> What the heck just happened and short of dumping these tables out and
> importing them back into the other database...
Most likely, you accidentally added the tables to template1, which then
propagates to any new databases added after that.
Clean up template1, then clean up your existing databases, and you
should be back to normal for any new ones. dump/reload is not required,
except to get tables into databases which need them.
- Thomas