Refactor VCE RARE asset checks

[jdangerx]

Tasks

Preview Give feedback

1. Review asset checks and see if their memory footprint can be reduced
2. Remove any asset checks that seem low value and resource intensive
3. Accumulate an error report and return it if any of the piecemeal checks fail
4. Fix the expected row-count asset check so that it can pass in the fast ETL

[zaneselvans]

Most of these issues were addressed in #3959 but the row-count check still only passes if all data is processed, meaning the fast_etl will always fail if asset checks are enabled, which they should be.