Any sight other than a retro style that you install in the GI dovetail is going to look somewhat, well... "different".
Having Novak slots milled into your slide would give you the most options. Note that some of Novak's adjustable rear sights have adjustments for both windage and elevation, while with other models you loosen the set screw and drift the sight to adjust windage. The main expense will be having the slide altered of course.
The Harrison retro rear with some type of bead or dot front provides a really nice sight picture. Much better than standard GI sights.
Whichever route you take, if you decide to install a staked front sight it's important that the installer knows how to do it properly. Once installed, the front sight cannot be removed without damaging it and it cannot be reinstalled.