Targets - do they just keep going up?

I'm fairly new to being an account exec - my first year has been a mix of incredible levels of stress, an impeding sense of doom and feelings that I could close any deal that an SDR threw at me but in Q1 I finally cracked it and was the top closer on the team and smashed my target.

Now I'm feeling like I need to continue this momentum as the only thing that motivates me more that money is the fear of people thinking that I'm a failure my targets keep going up every quarter despite last quarters results

Is this normal? Do they ever stop increasing? Is there a limit to how much ARR a rep can close?

Personally I don't want to be an enterprise rep (which is what I'll become if my targets continue increasing) and am happy closing SMB/mid-market deals until the cows come home.

It would be useful to understand how this works in other organisations as I've only ever worked in one SaaS company.

Thanks!