Do you put out colorful pots/flowers/porch furniture for the summer months? If not, I'd start there. If so, can we see the colors?

I would not paint the pillars a different color from the rest of the trim. Personally I like what you have now, but if you want to add some brightness, you can certainly paint the front door something fun.

You might consider some bright landscaping in front of the porch. What you have now is pretty neutral. I also really like @Sammie J idea of planter pots with colorful flowers.

I wouldn't paint the pillars either. Look at SW Urbane Bronze for the front door, or forest green.

Those homes are stunning!

I’m a little weary of a bright front door. Just personally my taste for my house.
I do lots of greenery in pots as it’s somewhat shady.
We are planning on doing a bit of landscape this summer and adding grasses and low shrubs. I like a contemporary minimal look. The home is traditional is style so I need to keep that in mind.
We have black 1950’s tulip chairs on the porch typically.

I would consider one of these Benjamin Moore colors in high gloss enamel.

I like this deep orangey red. You have a beautiful house!

Here’s three Benjamin Moore colors using coleus as inspiration.

Guessing the paint on the house is Agreeable Gray, so S W suggests this color as a coordinate.

The color of the leaves on your neighbor's tree looks nice with your house. What about a color like that, similar to the Bordeaux Red recommended above? On just the door; I'd leave the pillars alone.

Love the Aegean Teal from houssaon.

I also like this Still Water from SW. Would not paint the pillars.

Agree that you should leave the pillars as-is and paint the front door a color that announces itself. Doesn't need to be bright, just different from the trim color. You could choose almost anything because the rest of your house is very neutral. This is an aubergine - it kind of picks up the neighbor's Japanese maple. I would also add some color in your landscaping and put some pots on the porch.

If the door is too dark, it won't stand out from the shadows.

If you are referring to your porch columns they do look undersized. I would suggest beefier columns and bases. If structurally possible I might suggest removing the center column and having one column at the corner. That might mean you would have to install a deeper beam from the column into the side of the garage.