I can't help on the DBIx::Simple topic, but the latter seems more stable, hence you do not hardcode the new() call on Catalyst::Base. If I understood correctly, Catalyst::Model is also the right base class for models now.

So, I'd vote for the latter.