Okay, hear I go.
1. Coda does have some similarities to D&D 3E. So what? In my opinion it is far more flexable. The Innovative edge and the professional ability of Rounded mean that no skill or professional ability is out of reach so you are not restricted to abilities from your class as with D&D. And just for the record, I hate D&D 3E, but that doesn't stop me from liking Coda. The difference is flexability. There are no automatic increases with advancement, it is completely up to you what you increase when you get your points. If it bothers you that non professional skills cost more then think of it this way, the nonprofessional cost is the normal one and the professional cost is an advantage because you have trained extensively in the skills that you make use of most.
2. As to Odo being a Soldier, that makes perfect sense. In the professional development section there are packages listed for each profession. One of the packages under Soldier is Law Enforcement Officer. This package contains the base skills that a cop would need. Also, saying that cops don't need weapons skills in their profession because Odo did not use weapons doesn't make sense. Odo had an edge most cops don't, so he did not buy the weapons skills that are available to Law Enforcement Officers and instead focused on the investigative side of his profession. This is perfectly in keeping with both the rules and the setting.
3. Having said all of this, enjoy playing whatever game floats your boat, it's all for fun anyway.
4. Shooting is not too good for my enemies.
Evil Overlords Survival Guide
There are few problems in the galaxy which cannot be solved by a suitable application of concentrated phaser fire.
Capt. Coryn Windsabre
I've always preferred photons myself.
Cmdr. Marcus Aurelius Ferretti