As indicated by the comments, it depends on how the sequence is defined.
One exception will be the digits, base $m$, of an irrational number, e.g. $\sqrt 2$ or $\pi$.
Another would be a random sequence e.g. generated by a coin or dice toss.
However if, like the Fibonacci sequence, the next value is determined by a finite number of preceding values then it will be periodic. In the Fibonacci example, the next value is determined by the current and previous one then there at most $m^2$ possible states and hence it must become periodic within this limit.
One of my own previous questions is on this topic.
Fibonacci sequence in $\mathbb{Z}_5$
Clarification
My periodic case assumes:
The values are from a finte set e.g. $\mathbb{Z}_m$
The next value is determined solely by the current value and a fixed
number of preceding values. So, $a_{n+1}$ is a function of $a_n,
a_{n-1}, ..., a_{n-k+1}$ for a fixed $k$.
The position in the sequence $n$ is not available to the function.
Although the sequence will eventually return to a previous state and then become periodic, it might go through some initial states which are not repeated. It will be rather like the decimal expansion of a rational number. There will be degenerate cases in which the period is $1$. The sequence enters a state and get stuck there. A simple example is a Fibonacci like sequence with the initial values $0, 0$.
In some cases, including the Fibonacci sequence, the relationship will be reversible. I mean that you can calculate the previous value from a finite numberof values. For Fibonacci:
$$a_{n-1} = a_{n+1} - a_n$$
In these cases, the sequence will return to its initial state and be periodic without needing to ignore a prefix.
$$1,4,3,6,9,10,\cdots$$
can be generated by
$$a_n = \begin{cases} 1 & n = 1 \ 4 & n= 2\ 3 & n = 3 \ 6 & n = 4 \ 9 & n = 5 \ 10 & n = 6 \ \vdots \end{cases}$$
There is nothing deep hidden in this sequence, it is simply a random sequence of numbers I made up. The same is true of many sequences. Some just have nicer definitions than others; others are defined piecemeal. And there's probably no meaningful way to distinguish between them.
– PrincessEev Jul 22 '22 at 20:35