Oh dear, my advice was "go and develop a crush". It's really highlighted to me how I'd like my DH to make me feel (desired, desirable) and the qualities I would like to see him display (smiling, humour) and, well, it's fun, y'know. Thinking. About stuff.
It doesn't help FIX anything but it scratches an itch.
But I can see you and I are already in that "Well, this feels nice but let's try and inject some of this back at home" with a man to whom I am invisible. I grew out my hair, lost weight, hit the gym, got the ass and the abs and dressed better, and it worked a treat because yeah, now I get male attention and I feel really confident and pretty. And the only one I was trying to impress never looks up.
I just spend more time with my crush.
Probably not going to help in the long run.
I've suggested an open relationship.
I guess I'm not exactly full of good advice, but basically - I feel for you. It's a tough situation to be in, but in the end, we only live once...