Re: Dual SIM - Moto G II
Moto G II dual sim capabilities (only dual SIM I've ever had so nothing to compare with, still using factory 4.4.4 Android, no relevant add-ons)
For calls+SMS: it's pretty much spot on. You can have either or both SIMS active at any time, for incoming and outgoing. For outgoing calls, you can select a default-SIM-for-everything, default-per-address-book-entry, or prompt for SIM every time. Auto-choose SIM depending on location and/or auto-choose SIM depending on coverage would have been nice. Maybe if I let it update the software (like it's been asking to do for ages) they will magically appear. More likely something useful will disappear, so I don't let it update.
For data (incl MMS): not so clean, but I'm not sure why. If you've got both SIMs enabled, effectively only one can do data. Thus if you've got to send an MMS on the "wrong" SIM (so it appears to come from e.g. the business rather than private number), it's a bit awkward; if you have data and coverage for both SIMs, it will switch briefly to the other SIM, send the MMS, and switch back again, which may not be a huge problem.
On the other hand it's tedious if you need to send an MMS on the "wrong" SIM for coverage reasons. E.g. I have EE and O2, my published number is O2, my incoming stuff (calls, texts, MMS) is O2, but for coverage reasons I am increasingly using EE. If I get an MMS on O2, and am in the "wrong" coverage area, replying to it is a bit of a nightmare. Why is it this hard? No idea whether it's architected like this in the standards, whether it's a restriction of the chipsets (?seems unlikely), or whether it's a fixable restriction of the software.
This may or may not be a niche use case.
Sound profiles etc are typically selectable using something built in or a freebie add-on, regardless of SIM implications. The Moto G has a built in app for this kind of thing but I haven't used it for ages.
Day to day? It works for me. It could be improved. Because I'm using it for coverage reasons, it suits my voice and SMS usage. It's less convenient for data+MMS usage.
Obviously the G II is now superceded by the G III. I've seen no mention yet of a dual-SIM option, and wouldn't personally be fussed anyway. The G II does what I need (mostly).
Best of luck with your search.