If your question is do you need an overhead light and two lights then I would say no it’s a small area. But you need at least a light in your entry

I'm confused because it looks like you already have 2 round junction boxes on either side of the door opening. Are you considering adding additional lights on the stone columns? Your inspiration pic shows 2 wall sconces on the columns but also some other kind of light under the entry roof that illuminates the entire entry and really draws the eye/visitors to the entryway. Perhaps it's some kind of ceiling light, or strip lighting; I'm not sure. Plus, it looks like the front door in the inspiration photo is full glass (which is not practical in my opinion) and they photographed the house with all of the interior lights turned on, so it's creating a different look than usually seen on homes with solid doors. I'm not sure how it would look with 4 wall sconces and no ceiling light, but I don't think it would achieve the look in your inspiration pic. You could use walkway lights to illuminate the walkway up to the front door.

Sorry, I wasn’t clear, I have a 42” door with 12 inch side lights. The two round junction boxes on either sides have been removed due to the side lights. I do have a 4 inch” ceiling light under the entry roof. So yes, I am considering adding scones to the stone columns.

I don’t like the ppl of lights on the stone. I would simply use one overhead.

You need the one overhead so you can see who is at your door at night. If you put a light on each stone column, that will be for lighting the walkway/entrance to your home and for decorative purposes. I think if you look at most homes in your area that have columns, you will find that they have a light on each one (just like the pictures of inspiration houses you posted). Just an overhead light with dark columns may functionally work, but will look less welcoming if you view your house in the evening and early parts of the night (most people turn them off when they go to bed).

That’s what I was thinking. The light under the over hang would be turned on only when someone is at the door so I could see.

Side question. Adding the scones to each stone column was something I thought of after the fact. Can the electrician T off the light under the over hang?