Size of the FO rod and color make a difference.
I had one pistol with a FO front sight on it, XDM 5.25 9MM. Amber/red. Hated it. It was like looking at a big red softball on the end of the slide. Shot the irons (with my glasses) much better on the 3.8" XDM 9MM.
Years later I got a CZ Tact. Sport with a smaller diameter green FO front sight and I like it. I like it a lot. It's there. I can see it. It doesn't jump out and overpower by eyes..
Also, if you get a red dot on your pistol you may be affected by the color of the FO front sight vs. the red dot. I had a DP Pro installed on my wife's CZ75 Compact with a red FO front sight. The red dot in the DP Pro and the red FO front sight confused her. Changed the front sight to green and she was happy as could be. One red, one green, no worries about which one she was supposed to be putting on the target.