something calm and light to contrast the dark cabinets.

Modern white oak, matte finish

Perhaps you can get some engineered wood samples to lay down in your space to help select a color. A hardwood floor contractor to do a wide variety of stains and finishes. Nothing too dark or too red or too yellow.

Hardwood floors throughout that whole space including the kitchen would look lovely.

A very light color. I too am curious about replacing kitchen tile with wood.

Whatever flooring you decide on, it’s important to create a smooth transition and therefore furniture and accessory choices will be key. If buying, suggest light furniture with pops of black and island seating that has the same wood tone as the flooring.

I'd go with a dark quality laminate...something that will not fade. Bring lighter furniture in to balance both sides of the space.

The goal should be to have the same continuous flooring throughout most of the home, with tile only in the bathrooms, laundry, mud room and in a cold/snowy climate maybe the foyer, if it is your main/only entry.

I would keep the carpet till I had the budget to replace it and the tile, with engineered wood or site finished wood floors.

My vote below is one wood flooring for the entire space.

But, if you move forward with two types of flooring (tile and wood), be careful that the subfloor in the carpeted area is the appropriate height so both floors end up level. If the subfloor needs to be raised, be aware that it will increase the install cost. Also choose a skilled contractor that can butt the two floorings level against one another without gaps.

Don’t allow the contractor to install the wood floor at a different height than the tile floor and don’t allow them to run a ”transition strip” of metal or wood between the two floors.

Both flooring same, no matter what.

It's a "brand new" ( remodel ) or build, and given northeast locale, no idea why so much tile.....

You have or have not bought it yet?

I'd find a logical spot in foyer to cut and make a transition and then rip all the kitchen flooring from whatever that point is.

Maybe right here, at the closet wall?

Either repeat what the builder put in, add area rugs, or rip all to a light wood flooring. Bedrooms are carpet, stairs are carpet, all is builder grade, EVERYTHING.

Depends your resources following purchase, If it's an actual purchase as it still shows as a listing.