NCMs are much more then just followers, eventually you will be a leader, even as a NCM. Also, both NCMs and Officers will follow orders as you will always have a boss.
I know some NCMs who make far more then some officers. As for more paperwork, both NCMs and Officers will do paperwork. Again how much will depend on your employment, etc. As for advancement, there is room to advance in your career as both a NCM or Officer. Also as a NCM you may apply to be an officer and get your commision - different ways/programs to do this.