It's definitely possible, but there are pretty specific conditions you need. The big debris - like rocket stages or dead satellites - can actually be seen with the naked eye when everything lines up right: a moonless night, zero light pollution (so in the Paris region that's tricky, you gotta get pretty far out), and above all good atmospheric visibility. It's not science fiction, there are regular observers who track this stuff with their apps for exactly that reason.
On the other hand, it's true that small debris, like fragments a few centimeters across, you can forget about. You only spot those with a telescope or radar. But the more massive objects - certain dead satellites, the big boosters - they reflect sunlight and can shine as bright as medium-sized stars for a few minutes. If you use an app like Heavens-Above, you can see all the predicted passes of the Station, but you can also find passes of certain major debris. It's less regular than the Station but it happens.
One practical thing people often forget: before you check the apps, look at observer forums (there are communities on Reddit, or even French sites dedicated to it). They post when exceptionally bright debris is going to pass near you. Because waiting for the right moment just scrolling through the app takes forever. And honestly, find yourself a decent dark spot in the suburbs away from cities - it's half as dramatic as you're probably picturing the conditions.