Pro/Cons: Teams using Dynamic View vs the Sheet itself


I am looking for your thoughts about teams using Dynamic View vs going directly to the sheet itself to add new line items and editing. Reason for the asking is that I have some teams that are used to working with Excel to manage their list of activities and the quick copy/paste abilities you have there. In Dynamic View, you're locked with the side panel form for new and editing steps. BUT in the main sheet you have the possibility of data integrity issues and it not being able to require certain fields to be completed (like in a form...required element).

What are your pros/cons of using either?