Let's use a simplified version of your 'naive' view (which isn't really naive), and imagine that you had a table of just 100 random numbers to select from, with the seed being a simple index into that table (from 0 to 99), advancing 1 place every time you grab a number, and resetting to 0 when it gets to the end of the table.
When your program starts, the seed is at zero. Grab a number, now it's at 1. You can grab a further 99 before you get to the end of the table, but as soon as you grab another 1 number you start to repeat the sequence. The periodicity of the random numbers is 100 (ie, they'll repeat every 100 reads).
Now you start setting the seed value. In the extreme case, imagine you've set it back to what it was when you read the last number - the next read will get the same number again. In this extreme case, you've reduced the periodicity to 1.
Less extreme: You choose a seed that jumps the seed forward 20 places. Now you can read 80 values before the numbers start repeating. You've reduced the periodicity to 80.
Another example: You choose a seed that jumps the seed backwards 20 places. Now you can read 20 values before the numbers start repeating. You've reduced the periodicity to 20.
Note that the effect you have whenever you set the seed to any value other than its current value is always to reduce the periodicity, making the numbers you read start repeating earlier than they would if you'd left the seed alone. There's no case where you can increase the periodicity.
Although the random number system used by DBPro does not use an actual table of numbers (it's a calculation), it does conceptually use the same system with a periodicity of 4 billion-ish.
You could set the seed and reduce the periodicity to 4 billion-ish less a few, or you could reduce it to 10. The kicker is that there's no way for you to know, because unlike using a simple index to a table, the seed value is actually a by-product of the previous random number you grabbed.
If you leave the seed alone, you know you aren't reducing the number of random numbers you can use before you start to repeat the sequence. If you change it, you know you are reducing the number, but not how badly.