The higher the seed, the easier the path, so logically you would always want the highest seed. However, seeding also sets the expectation.
I'm always happiest when our performance exceeds expectations. When you're the 1 seed, you are expected to reach the Final 4. If you don't, your season is a disappointment. At least, that's the perception.
I would have been pretty happy if we had won the NCAA tournament in 2020. We had the best team, and should have won it all if the tournament hadn't been cancelled. But nothing beats the pure joy of a 6-seed advancing all the way and winning the whole thing (e.g., 1988 Danny and the miracles). Expectations were pretty low that year. We had a flawed team, and lost 3 times at home, so the run through the tournament was truly unbelievable. Winning it all when you are expected to is pretty cool, but doesn't come close to the rapturous delight from that kind of miracle run.
So I will always want to be the highest seed, but if we have a few hiccups during the season that hurt our seeding in the tournament and lowers expectations, that translates to less despair if we lose in the tourney, and greater joy when we win.