When searching a room I give people options. Are they just doing a quick search, are they being careful to leave no trace? How careful are they being to not trigger trap? Are they just going the tornado route where every piece of furniture is smashed, every vase broken, floorboards pried up? Do they escalate if the don't find something quick and so on. A quick search can be done in a few minutes, trashing the room could take an hour or more.
I don't usually go into specifics unless and until it's reasonable that it matters. If you're just totally trashing the room, you'll find the secret compartment. If you're trying to be careful and not leave a trace but also taking you're time I'll give the best of passive or roll for investigation.
But this goes back to my relying more on event-driven than location-driven sessions. Searching a room and whatnot, can take a long time depending on how you handle it. It's also something that typically leaves most of the party "guarding the door" while the rogue does all the actual work in my experience. So I'd rather hand-wave and fast-forward most of it with high level descriptions of what the party is doing. I'm sure that's not every body's cup of tea.