I faced the exact issue yesterday and followed this video to make it work. However there is a catch, [email protected] is no longer available via brew.
https://www.youtube.com/watch?v=6FFjYy_f2Ls&t=572s

Then I found someone has it hosted and could install it with the following comand. As someone pointed in a reddit post. https://www.reddit.com/r/macgaming/comments/1gbs6vw/gptk_cannot_be_installed_because_of_openssl_11/

brew tap rbenv/tap
brew install rbenv/tap/[email protected]

Then did the recomended by Troubleshooting connection problems in the Microsoft ODBC Driver guide. https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/known-issues-in-this-version-of-the-driver?view=sql-server-ver16#:~:text=Some%20macOS%20users%20encounter%20the%20following%20error%20with%20driver%20version%2017.8%20or%20older%3A%0A(This%20error%20has%20been%20resolved%20in%20driver%20version%2017.9%2B)

rm -rf $(brew --prefix)/opt/openssl
version=$(ls $(brew --prefix)/Cellar/[email protected] | grep "1.1")
ln -s $(brew --prefix)/Cellar/[email protected]/$version $(brew --prefix)/opt/openssl

dont forguet to also add

  'TrustServerCertificate=yes;'

Hope it can help somebody facing the same issue.