I've dry hopped for different periods of time with mixed results. You have to remember there are a lot factors that go into what your finished beer is going to taste and smell like. Quality and freshness of the hops, the specific varietal of hops used, amount, length of time, temperature at which you're dry hopping, and then the entire rest of your brewing process leading up to the dry hopping stage.
Anyway, I recently came across a study done by Peter Wolfe at Oregon State (just realized this is likely the same study referenced above) that concluded dry hopping for only 4 hours, WITH agitation, extracted nearly 100% of oils and aroma compounds. There is also a brulosophy beerexperiment in which he dry hops for only 1 hour, also WITH agitation, and the results are similar.
I recently brewed a pretty simple citra pellet/mosaic cryo NEIPA. Big whirlpool, ZERO dry hops in the fermenter..transferred into a purged keg with 4 ounces of citra pellets, and one ounce of mosaic cryo in a large hopping bag. I left it in there for only 4 hours at room temp, and agitated the keg every 30 minutes by shaking it pretty good and rolling it back and forth on the ground. I then put it in the fridge on gas for about 20 hours in which it chilled down to serving temp. I then opened the keg, pulled the bag out, purged it again and left it in the fridge for a few days.
The beer has as much aroma and flavor as any other beer I've ever made, including ones that have been dry hopped 2,3,4 times, 5 days, 7 days, 10 days, etc..
Take what you will from this little experiment but I see no reason to go back to dry hopping for any long periods of time.