I've also been really excited about a solution only to realize that my excitement was with the underlying technology rather than the customer experience.

I remember this feeling with early web apps. I was excited about being able to update one system rather than several desktops. For the customer, however, the overall UX was actually a slight step down because of the limitations of HTML and javascript.