[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:

• [ ] #264
• [ ] #263
• [ ] #224
• [ ] #221
• [ ] #176