From 2000 to 2025, $10,000 in the Nasdaq 100 and the S&P 500 ended in a near tie. Here's why the hotter fund isn't always the one that leaves you richer, and which one fits you.