How Notion handles pasted Markdown vs Web Clipper
Web Clipper saves a frozen rendition of the page: useful for reference, useless for working. Pasting Markdown into a Notion page invokes Notion's Markdown parser: # becomes a heading block, - becomes a bulleted list, fenced code becomes a syntax-highlighted code block, pipe tables become Notion table blocks. Every construct becomes editable, searchable, and database-linkable.
Database integration patterns for clipped URLs
The high-leverage workflow: a "Sources" database where each row is one converted URL. Properties: title, source URL, tags, status, date clipped. Body: the converted Markdown. You can then filter by tag, link from project pages, query across sources: all impossible with Web Clipper's opaque preview blocks.