I find your scenarios very plausible and think it makes sence to let the app make all the autoswitching of network connections (background connection ON/OFF!!!) and profiles.

Why not to make an approach like this: You can create x "Phone Modes". Every mode is based on several IF conditions like time or proximity to a WiFi. Of course you would need to detect overlapping IF-conditions.

And on every phone mode you can simply choose from a list of actions, eg. Select profile [x1, x2, x3], BGConnection (on/off), etc.