So The Sims Complete Collection? I have The Sims Deluxe Edition and all the expansions installed (although I haven't been on it for a while), so I will try to answer these as best as possible.
1. The cockroaches do not seem very common in my version, they only appear every now and then when there is a huge mess (For Example: My sims eating out of a can of food and leaving it on the floor). I am not sure if there is a mod for getting rid of cockroaches, but you can check Sim download sites online possibly Sims Resource.
2. This one is inevitable it seems. There is little or none at all when the floor is complete (Tile, Carpet, etc), but when on ground the water stretches into puddles usually covering most of the room.
3. Repairs is also inevitable, for me the only thing that constantly breaks the most is the toilet or the computer.
4. I'm not sure of this one, I never delved into daily/lifetime relationship bars for Hot Date or celebrity status Superstar.
5. If I remember this one correctly The Sims despite not having free will, will try to satisfy their needs after it reaches a certain low point. I've only messed with this option a few times, regardless I decided to give my Sims free will because they will leave their spot I tasked them to.
6. Haven't run into this problem, I just get the typical mouse icon with the light/star/flash on the tip of it.
7. The social interactions is odd though, I have all of the interactions intact (are the Sims relationship levels high?). I don't know about asking marriage more than once, although having kids I get the option every now and then. You can always try the Love Bed and see if you can get the interaction again.
I'm not sure about the complete collections since I have the expansion packs and stuff packs on every version (2, 3, 4), but my guess that with the Complete Collections they try merge all expansions and fix any loose ends or bugs before moving onto the next game. It could also be the Operating System or the hardware on your computer that may also affect the game.
