I liked Wes a lot, same with Fred/Ilyria, but none of them were my favorite characters in the series. However, if you look through the entire Buffyverse, through all the episodes and all the relationships, this is the single most touching moment of either show.
There are other relationships that have more pure romance, but seeing Wesley like that, when he knows he's done and there's just nothing left for him in this world, after everything he'd been through (probably more than any other character), there was never a moment that got to me more (and I'm a such for just about any moment between Buffy and Angel). I still watch that moment and tear up (not even close to a joke).
Is it romantic? I don't know. I don't think there was ever a more heartfelt moment, where we've just felt so much for one of the characters.
It might be the best part of the series though.