I use Cursor in anger every day. The core idea behind Cursor is genuinely smart. But the execution is like the classic "unfinished horse" meme [0].
Microsoft provides the editor base, foundation models provide the smarts, and Cursor provides some, in my experience, extremely buggy context management features. There is no moat.