Hi Deveno,
I don't really follow you, I'm probably missing something :)
Just to answer your first question "does there exist an algorithm for computing the n-th digit of pi, BESIDES computing pi to n digits and looking it up?" there actually is such an algorithm :
Bailey Borwein Plouffe formula
But I don't think this as any say on computability of numbers and certainly not about rationality.
(By this I mean that, being able to compute some n'th digit of a number *as is* (without prior knowledge of the previous digits) probably does not have anything to do with the easyness of the computability of the number as the result of some infinite sums or whatever (on the other hand, it seems trivial to me that in fact, if you are willing to cheat, having an algorithm to compute a number to infinite precision implies that you can create a derived algorithm that gives you the nth digit by cheating, the problem is that this cheating would be so hard to measure (with abstract definitions of algorithms of arbitrary sizes) that it probably is not so useful to dig in this direction))
Your next question is weirder, you compute a number with an arbitrary rule that plays with decimal expansions of √2 and ∏ to create a new number.
Yes it is most certainly computable, but being computable is not related at all with being 'some sort of rational'
It would be hard to prove that Deveno's number

is not a rational number but I am fairly certain it is not
As for rationality: a rational number is called this way by its virtue of being the ratio of two integers (that can be of any *finite* gigantic size you wish)
it is a direct consequence of this definition that its decimal (it doesn't have to be decimal, it could be any basis) expansion will have an infinite *repeating* pattern (if you take 0000... as part of it (or it will be finite if you don't))
There is nothing else to this 'pattern thing' so to speak. if you create a pattern that 'looks simple' but is not an exact repetition forever, then it is just not a rational number.
You may want to classsify the toughness of the patterns so as to create some sort of intermediate categories of computable (but not rational) numbers but I don't think that would lead you very far.
For instance, Pi is such a number since the algorithm you were asking for does exist. the 'pattern' just happens to be a bit more involved than some other more trivial examples, but I really don't think that sets those numbers appart.
Pardon me if I completely missed your point, I am aware it is quite likely
Cheers...