When I found out about dark energy (or more particularly the accelerating expansion of the universe), I was devastated. I'd grown up hearing about the different models of what might happen in the future, and I completely believed that what we'd have was a Big Crunch. The idea that the universe is in a constant Bang-Crunch-Bang-Crunch cycle felt "right" in my child-brain - it had a wonderful symmetry to it, and I felt like I could almost imagine eternity when put like that. So to find out that, as we understand it right now, we're heading in the end for an eternal darkness and that this universe is truly a once-in-existence event, so that when it's over its OVER... yeah, that kind of bummed me out. But that feeling definitely falls into that weird category of my love of science where it comes closer to belief than true science.
My 'favourite' was the model that said the universe would expand but that the expansion would get slower and slower, and so essentially a limit could possibly reached and everything would settle down. That would have been nice
But the thing that really got me was finding out that there's a limit to how far out (in space and time) we can actually see into the universe. Everything we'll ever discover is trapped inside a horizon and nothing from beyond that horizon will ever reach here - ever. It's a bit ridiculous that that makes me sad, but it does.