doc: Improve CREATE VIEW / WITH documentation

Similar to 590eb0c14eebe834f716721a9659b77899cf3084, remove the options
list from the synopsis and elaborate in the main description.
doc: Wording and formatting improvements in new logical decoding docs
doc: Fix typos

per Andres Freund