Now that I had enough time to poke around and deploy Windows on a separate drive to do additional testing, I have found out that this issue is with the Nvidia Linux driver implementation.
Additionally, I have finally found this thread on Dev Nvidia forum:
I have created a small bash script that I can use to switch between desired refresh rates and minimize GPU power usage, based on my needs.