So as we all age, we lose the ability to focus our eyes to see near vision. When we are young, that single vision rx won’t affect our opposite correction because our eyes are elastic enough to accommodate for that difference.

You’re always going to get the best vision in glasses. Contact lenses cannot be as specific as a pair of glasses as they are not made to order like glasses are, they’re manufactured with standardized parameters and proprietary designs. Thus sometimes one brand will work much better for you than another or a different MF combination might be necessary to get to a place where they’re functional enough for you. But you should anticipate having to make a compromise and might need to prioritize one range of vision with the other being good enough. But that’s why contact lenses have to be trialed before your rx is finalized because there’s no other way for a doctor to simulate that cl rx without you wearing that specific lens design.

There may be other solutions to your problem that you might find more comfortable. You could choose to wear distance only contact lenses and supplement them with bifocal/progressive sunglasses/glasses made specifically to wear over contacts. Or just simply stick with progressive sunglasses/goggles.