hi jeroth, my personal opinion, and please don't understand it wrong, is that you are overreacting. You cannot have a plug&play approach with any software. I bet you that even using Aperture you might had "issues". You are just pretty use to Lightroom and want any software to act as.
C1 needs a lot of training is not a software for the masses, however, once you understand what is behind, you will love it.
I'm not paid by PhaseOne, nor sale their product or something similar. I am a simple user, that migrated from Aperture not so long ago and invested a good amount of money being trained (the Webinars are really good but will not help you to make the jump from beginner to medium user), they will help you more to learn some other tricks, etc. I will recommend you getting the training from LuLa and read.
You are also a Nikon User, I don't know how the colours and quality of the image of your camera are, however, the C1's colour rendition of any Nikon file compared to Lightroom will blow you up. Really, you should breath calmly, understand the software and you will be convinced.
Issues, yes it has a lot. The DAM is still in diapers compared to Aperture or even Lightroom. Keywording was bad in Aperture compare to Lightroom, but in C1 is worse as it best.
If you really want to get the best of your files, I will recommend you trying C1, otherwise, Lightroom will serve you in average pretty well.
Cheers,
Daniel