Lily Aldrin - How I Met Your Mother. 
A wife that will allow me to hang out at bar, lets me have a lap dance with a stripper that looks like her, and would just be full on supportive the rest of the way? I'm sold. Plus, she's a redhead. NICE!
Although, I might not like the sharing the toothbrush thing...
That is a good one and I think hits the real premise of what this thread should be.  
Monica Geller Bing came to mind for me immediately.  I think she might have been a little too neurotic for me, but if I could get past that (or find it cute), she would have been a great wife.  Cooks, cleans, lets me hang out with friends, has her own career, wants children and is good with them, etc.