want to make the most of our time
There are several takes on that sentence. It could say "see several large cities, even if it means little time for each of them". It could also say "spend as much of our valuable vacation time actually vacationing rather than traveling".
It's your vacation, and only you know what you and your fiancé are going to enjoy most.
Therefore: Yes, it is possible to go to Paris for two days. Yes, you are going to spend a large portion of your vacation time on pure travel: 4 hrs for the train ride alone, + getting to the station/ to the hotel, packing, unpacking - probably closer to a 6 hrs total each way.
So you'll have to decide if that's worth it for you.
Weather-wise it's hard to predict what you are going to get. There definitely always is a chance of rain, so be prepared for that. Near the coast, it can also get quite windy, and we do get a few storms in this part of Europe during fall.
That said, October can be quite beautiful if you are lucky, with golden fall foliage on the trees. If you do decide to spend your time in Amsterdam, maybe you can actually do some exploring by bike and enjoy some beautiful golden fall days. If you like to take pictures, look for the golden light of the low setting sun plus the golden foliage.
Temperatures in October can range anywhere from 0°C to 20°C. Amsterdam, being near the coast, has a moderate climate without great temperature extremes.