The nacelle lowest down in the pic that 9thDawg posted looks the most promising. Still keeps the general style of the TMP nacelle, while obviously updating it for TNG-era appearance.
Maintaining the same general layout of the TMP connie, it's weapons compliment should end up around:
2 saucer phasers (dorsal and ventral)
1 belly phaser (under stardrive)
(and for TNG-era which tends to have additional phasers to cover all angles)
2 aft dorsal phasers (small ones on top, at back end of saucer)
2-4 pylon phasers (dorsal and/or ventral)
I would suggest a "round" forward torpedo tube in the neck of the ship, rather than the blocky dual torpedo tubes of the TMP version. Looks more modern, and we've seen several ships which can fire multiple torpedoes from a single tube (such as the Galaxy Class). Perhaps 1 forward tube, and 2 aft tubes (embedded into the hull underneath the stardrive).
Total weapons count:
7-9 phasers (depending on amount on pylons)
3 torpedo tubes
Additionally, both the saucer phasers can be split up into 3 phasers each (Ambassador-style), with 1 section facing forward, 1 facing left and 1 facing right. All and all, they would be as effective as a single "ring phaser", but will probably look better.
The Intrepid Class has 11 phasers and 4 torpedo tubes. So while both ships may be in the "Cruiser" section, the Intrepid would still be more heavily armed. Giving the TNG Connie a bit of an edge in maneuvrability and top speed would be an idea, and have shields on a similar level to the Intrepid.