Ok, so, I did some thinking here, and some planning.
I have come to the conclusion that a RES may *not* be the best turtle for me, just because I don't really know what the future holds for me yet. A 40 gallon tank, and maybe even a 60 would be probably ok for me right now, and I can afford a Filstar XP3, so that means I'm pretty set up to that 60 gallon size. When a RES, and they almost assuredly will, exceeds that size, I don't know where I'll be when that happens. I might not be able to swing a 100 gallon tank for size alone, let alone cost and the whole new "startup" expenses.
I also took Steve's advice and looked at Turtle Rescue LI's page, and I realized that while I might be able to get hatchlings from them, I also don't want to turn my back on older turtles that may be harder to adopt out. I'm also willing to consider less than ideal ones, as again, they're hard to adopt, so a stunted one or one that had a rougher start in life would work, but again, size becomes an issue. This leaves me with something of an issue.
I know that these guys can live to 40+ years, and even if they're unhealthy, maybe that's down to 30 years if they still get proper care and an environment that's good for them. I consider it an obligation and a must that I should be able to reasonably commit to that timeline, even if, say, I have to adopt my turtle to someone else down the road for some reason. This brings me back to the issue of their adult size and associated problems.
Doing some added research, I have some suggestions from others of species that will stay much smaller as adults, and in some cases, are as a species very friendly and loving. Here's the list others have offered up, and I'm really open to any of them (though I still haven't closed my mind to RES or YBS or similar):
Cagle Maps
Musk/Stinkpot Turtle
Africa Dwarf Mud Turtle
3 Striped Mud Turtle
Reeves Turtle
The Reeves seem to get quite a bit of positive feedback as being very friendly and even somewhat attention seeking, which is perfect for me. I enjoy friendly animals, and would prefer one that won't try to take my finger away from me every other day for the next 40 years, lol. People suggest that there are some sex bred ones that are intended to remain small, though even so, they should only get to 6" max, and at the worst case would still probably be pretty happy in a 40 gallon.
The others are all pretty cute, too, and I'd be happy to consider any of them. Do you all have any input? Thanks!


