My husband and I have been together for six years and before baby was born I had basically no relationship with my MIL and saw her maybe 4 times a year. She is really crazy and always had a drinking problem, and I also believe she abuses prescription pills. Every time I interact with her she seems like she's high or drunk and it's impossible to have a conversation with her. Well since the baby was born 7 weeks ago, she has suddenly wanted to be a huge part of our lives, coming to visit once or twice a week. The visits don't last long - usually only about an hour, but she just irritates the crap out of me. Every time she comes over she bursts into tears when she sees the baby (she's really emotionally unstable) and then takes a million pictures.
To make matters more complicated, she was recently diagnosed with breast cancer (stage 3), and has "stopped drinking" (so she says). But she's still bat shit crazy and now she's got an excuse to be on painkillers b/c of the cancer. DH doesn't seem to think it's a problem that she comes over so much, even though I've hinted to him that I think it's excessive. I asked him yesterday "so I guess I just need to resign myself to the fact that she's coming to visit weekly now?" And he said "yeah, I guess."
UGHHH. It's just so annoying. So my question is - How often would you let your inlaw(s) come visit if you really didn't like them or want them around? Am I unreasonable for wanting to stop these weekly visits with my MIL? Should I push back with my husband and create conflict to get my MIL to go away? I'm willing to accept that I might be acting irrationally, but would really appreciate some objective input

Re: MIL Rant... Am I being unreasonable?
That said, if your MIL has cancer maybe it's best to let things be and deal with it with compassion. I know it's hard, but maybe you can figure out a way that the visits are more bearable?
I think the issue with my MIL is the unplanned/unorganized chaos she brings when she visits. If you know your MIL comes once a week, maybe you can get her to come on a consistent day and time and the visit time can have something where she can bond with you daughter and you can relax, or DH, baby and MIL can be together and you can just take some you time.
I see my MIL FIL and BIL once or twice a week for dinner. They usually take us out and buy us a meal from white spot or something. It's nice to get out and the amount of time is controlled so that could be a nice idea too.
Also my dad has made numerous slip ups by calling himself 'dad', but always corrects himself. After 30+ years of referring to yourself as mom or dad, it is understandable that it will accidently come out. It definitely bugs me too so I get it, but it could be an honest mistake