No passage in the repertoire should cause pain. A very small number of exceptions can cause some tension that might be unavoidable (looking at you, Erlkönig).In my mind, any problems with pain or tension are caused by too much tension in too many muscles and movements that are not coordinated right. With relaxed and efficient use of the body, these issues can be avoided.
I feel like some passages can cause that burning of the forearm, such as fast and loud octaves, but I can't think of anything that would cause tension. Perhaps constant extreme stretches like playing Rachmaninoff with small hands might fit the bill.
The tremolo at the end of the Hanon exercise book.