If you can find a trustworthy site to play at in the US then No Limit Holdem poker is still a profitable endeavour. I say still because the population gets better by the year.
Even though casino players are weaker it would be more costly for a learning player due to the higher minimum buyin.
If you're smart you could become highly competitive in 10-18 months as there are a lot of learning resources.