Just as it says above - if a username directs to my own profile, does that mean it's available? Some come up as inactive, but not all.

Yes! That just means it's never been used for an account (or possibly that the account has been deleted). To make sure you can search the name here: link