Restoring a database in production, even just a point in time restore from log backups, can potentially cause more harm than good. It's always seemed to me that the vast majority of requests to restore a database involve recovering data that's limited in scope, like a specific table.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho