A method that uses yield return is an iterator: it produces a sequence one item at a time, only as the caller asks for the next item. Nothing in the method runs until the first MoveNext (the first pass of a foreach), and it can stop early or even run forever, because the caller decides how many items to take.
That laziness has a trap: argument checks inside an iterator also wait until someone loops. To fail at the call, put the checks in an ordinary method that then returns a private iterator.
An async iterator returns IAsyncEnumerable<T> and can await between items, which suits paged APIs and files: the caller reads it with await foreach, and the next page is fetched only when the current one has been used. For cancellation, give the method a CancellationToken parameter marked [EnumeratorCancellation]; callers can then write .WithCancellation(token) on the stream.
An async iterator that fetches pages only as the caller reads, and the await foreach that reads it.