There's lots of magic in CDBI, such as stringification to the primary key (overloading stringification doesn't quite work right in Test::MockObject, test case and bug submitted), lazy inflation, etc.
While a C:DBI object is indeed just an object, mocking one 'by hand' via T:MO isn't simple.