How painful is it to use multiple Apple IDs with the MAS?

Not really, I personally used multiple account. You see update notifications for both accounts; however, to perform the updates for apps purchased with another account you have to manually log out and log into the other account.