[Meta] 'Zero-configuration' support for latest R and OS versions

[AndrewIOM]

Is your feature request related to a problem? Please describe.
People are frustrated that RProvider - on certain platforms, architectures, or R versions - doesn't 'just work'. People also get frustrated with the (sometimes) requirement to add R_HOME environment variables or specific fixes to the windows PATH, to name a few configuration quirks.

Describe the solution you'd like
All the latest OS versions (linux, macos, windows) are tested and work with the latest R version (currently 4.3.3) and require zero configuration for all standard R installations.

Additional context
The following issues form the basis for this issue:

• Be aware of installation problems in the documentation and with R path #264
• Add support for running on aarch64 architecture #263
• [Windows only] RProvider doesn't work with R > 4.0.2 #224
• Remove requirement for R_HOME environment variable to be set #221
• R.Net Initialization error on Mac resolved by starting from Xamarin from terminal #176