Completely agree. The first time I tried it was a disaster - hated what I was doing and missed what I did before. A second attempt a few years later when I was ready and I thrived.
Would you mind elaborating more on what changed from the first to second time? Did the situation change? Did your perspective/goals/motivation change? I'm currently in my first stint in management and really disliking it, and wondering if/when it might make sense to give it a shot again.