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

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

- [x] #264
- [x] #263
- [x] #224
- [ ] #221
- [ ] #176