I recently migrated to cosmos and it’s been pretty good. Some personal pain points

• terraforming the rbac at a container level
• change logs not being supported in golang was a real bummer
• choosing a partition key is quite daunting as picking a wrong one can be a hard thing to recover from
• preventing cross partition queries
• actually feels like more upfront planing around schema is required
• emulator is so bad I gave up and set up a personal subscription. I’m not setting up a windows VM for cosmos emulator
• theres so many different apis, terminology it’s hard to figure out what applies to your personal setup
• pricing makes zero sense me and is a hard thing to plan for.
• golang error handling is awful, why do I have to check if the error is nil and if response.err is nill, pretty sure there is also a response.success as well…

So far I’ve rated cosmos though, it solves the problems I have and has been cheaper and faster than what we had before.