In Notion you can specify how you want cards to open, I would love to see that in Coda as well.
Personally, I would prefer that Cards always open as pages, since the current preview window, especially on laptops, takes up a lot of space that would otherwise be available for the Cards content.