This might be useful for some unimportant libraries, but not for security critical libraries like OpenSSL. You should always use the system version of this library, because it is always on the most up to date version.
This is not the case on macOS where the system provided versions are, in some cases, ancient (eg OpenSSL 0.98.7). Apple specifically says developers should not use the system SSL libraries but should provide their own versions in the application bundle. I believe the reasons for this are currency (ie security) and incompatible ABI changes between versions.
As at March 2022, the latest OpenSSL stable version is the 3.0 series which is supported until 7th September 2026. This is also a Long Term Support (LTS) version.
The previous LTS version OpenSSL 1.1.1 is on life support until 11th September 2023 (at which point all support ceases, so no bug fixes for security problems) as OpenSSL moves to version 3 (now at 3.02) which has even more significant ABI changes.
All older OpenSSL versions (including 1.1.0, 1.0.2, 1.0.0, 0.9.8 and 0.9.7) are now out of support, contain multiple security vulnerabilities and should not be used if you value security and your reputation.