The biggest friction point for me is the fact that files can only cross the work profile boundary by using the Android’s share sheet (or with cloud storage, I guess), and some apps (cough cough Meta crap) didn’t like it when you shared a file they couldn’t directly access with them. I didn’t encounter any such issues recently though.

If you pause the work profile (there’s a button in the launcher to do that), all apps in it get killed and their icons and widgets in the launcher get grayed out. If you tap a grayed out icon, you get a dialog asking you if you want to unpause work apps. I think there are ways to automate pausing, but I don’t use anything like that and literally only have the pause/unpause button as a toggle for the intrusive apps.