Just came across this Doug Drexler video where Andy Probert walks through designing the Enteprise-D, highlighting some things that I didn't know about. Such as:
Watch the entire video here:
- The main bridge was almost placed at the rear of the Star Drive's cobra head.

- Ambassador was at first the class of the "D" not the "C"

Watch the entire video here: