Really depends on the application, no? I wouldn't want my IDE opening every file in a new window.

That’s why the windows manager and user should be in control

I’d love to be able to arrange different tabs of different apps in one window