Is there a Sub sweet spot?

[AllGoldRollie]

I'm seeking advice from experienced Rolex owners to purchase a nice everyday-wear, workhorse tool watch. I've decided to get a steel, black dial, no date Submariner. I'm looking to spend up to 15k. This will be my third major watch purchase, so I have some purchasing experience. I generally baby my watches, and I work indoors in a clean studio. My everyday activities are not highly physical, but I do want to be able to wear it on excursions on vacations without having to worry.

I have two main criteria: fit (the right size for my wrist) and function (it will run properly for many years). If I could have a third point of criteria, it would be value (its worth will increase over time, even if it is only a tiny amount). My main issue is that my wrists are slender (6.25"), which makes finding the right watch a challenge. Many modern watches (42mm or 43mm in size) are nearly overwhelming, and many vintage watches (around 36mm in size) are underwhelming.

Is there a model of Submariner with a size around 38-39mm, maybe 40mm (likely be a good fit for my wrists) that also has modern internal and external upgraded technology, making it a dependable everyday-wear watch? I want it to hold up mechanically without any out-of-the-ordinary malfunctions. Because of this, I'm not looking to buy a very dated model. Please let me know if you have any suggestions. I appreciate any help you can provide.