Even with root, the phone will prompt you every time an app wants super user access.
Nope. That is entirely up to the 'su' binary on your device. On mine, rooting simply meant I was able to alter things. It wasn't until I replaced the 'su' binary that I was able to effectively run things superuser, and the replacement binary (chainfire's supersu, incidentally) does the prompting.