Yes. Lets look to the consumer market for inspiration.... compact pixel pitch on a 135 DSLr sensor... must be in the 100's of MP. yeah. great? right?
Absolutely, it would be great. I'd kill for that. Image quality would destroy current DSLR sensors (at high ISO too), and it would act as a built-in optically-perfect teleconverter as well.