This is my experience too. Realism in testing is criminally underrated while code coverage is criminally overrated.
IME unit tests can only effectively substitute for integration tests where you're testing logical/algorithmic code with simple function inputs/outputs.