Fair. I always took as Things probably won't work out for Frazier personally. That he's stuck searching for it. Hence why the dorkier brother gets the happy ending

Sounds like Fraiser and to some extent HIMYM (with Barney) fits what you want. Not 100% but important characters on those shows spend their lives in pursuit of the "one" but don't necessarily get it.