Unless you rectify the water issues in construction aspects of the porch itself, the sustainability, longevity, and maintenance of any flooring flooring system and associated area construction will be in question (just like your wood floor and columns)unless you choose a system specifically made for an exterior application. With your porch in its current state, what comes to mind is a ceramic/stone solution made for an exterior application with membrane over mud-bed over menbrane construction and a drainage/gutter/flashing system (like at least Schluter Ditra/Kerdi or even better Troba/TrobaPlus with a BARA/BARIN drainage/gutter systems for porch/terrace/deck systems). as for tile product choices, a high quality porcelain is an excellent choice for decorative exterior applications. a high grade masonry sealer for the joints is advisable as well. The important thing here is to either: (1) fix the water coming in, or (2) use a system where water penetration is irrelevent. Please dont make the mistake of simply installing cement board and tile over the wood substrate to save costs. While it may last longer than the wood, you will still most likely get water penetration into the wood subfloor/framing system, which in time, will still deteriorate the underlying wood, eventually causing tile/backer board system failure. Nothing will last over a wood subfloor system over wood framing if you dont take the proper precautions. Here is a link that might be useful: Schluter Systems

I think you need to do a layout like a room. Can you post a diagram with dimensions, including doorways and fairs to patio? I just built a small porch, though its bigger than yours. Our porch was designed with BBQ in mind, but now that its real life and not a plan on paper, DH is afraid one BBQ flair up could mark porch ceiling or God forbid, cause a fire. Now, BBQ is on patio. But it can't be near the porch because then the smoke blows up onto the porch which is unpleasant for those relaxing on porch. Anyway, we don't plan to eat meals on porch, but we wanted that option. We wanted nice comfy chairs, not dining chairs. We opted to get a rectangular fire pit table with 4 nice cushioned chairs. It's a tight fit on our porch. We chose the fire put table because its higher than most coffee tables and you could eat there if you wanted to. We don't plan to use fire bit much for same reasons stated above for BBQ.

What kind of finish does your concrete have?...what does hubby not like about stained concrete?...will attach a pic of our floors...used stain that was about $60 per gallon...just spread it around ...no expertise or experience needed...added a coat of sealer for shine...this was an indoor application and the green was not recommended for outdoor applications but the finish takes it up many notches from concrete...won’t peel off like paint and looks like a real stone floor....

Real stone set with exterior grade mortar bed. A stone mason is the go-to person for this. Personally I like slate, but not everyone likes that material. The best options always come from LOCALLY SOURCED MATERIALS. It looks natural. You can start reaching out to local masons and ask them where they source their stone from...and that will give you a starting point. My brother is a brick/stone mason. All of his best work has been done using locally sourced stones from local quarries (or even left overs from rock slides that he picks up from the side of the highway...I kid you not!).