I am looking for a simple DCC transformer that allows me to get the most out of a DCC equipped locomotive.
I'm sorry but you need to clarify what you mean by "get the most out of". The more I think about it the less that means. What do you want it to do besides go forward and back, fast and slow, turn the head light on and off? Are you interested in speed curving, and setting your own CVs? That is not usually beginner stuff.
I've looked at the NCE Powercab and find it might be too complex for my experience level.
I don't believe it is any more complex than most of the others, in fact it might be easier than some. It is just a matter of reading the step by step instructions to do what you want and ignoring the 90% of instructions for things you will never want to do.
I've also looked at the Ez command transformer from Bachmann.
That seems to be the opposite end of the spectrum from the NCE. Bachmann also has a Dynamis DCC system which has much more functionality.
How many trains are you looking to run simultaneously? The NCE DCC-Twin is almost trivial to learn to use (entire user manual is only 8 pages), but it is very limited. It only does 2 trains and only on 2 channels without adding additional equipment.
The Digitrax Zephyr is a nearly fully featured beginners set that can run locomotives (up to 10 I believe) on just about any channel you want. Finally many people like the MRC Prodigy Express 2.