LR 5 has been out for almost 2 years. That offer of a free upgrade if you bought the previous version X number of days before the newer version came out is only good for so long then it expires.
So if you want LR 5 you will need to buy the upgrade version. Now if you do buy LR 5 and LR 6 comes out within 30 days of the date you purchased of LR 5 then Adobe MIGHT, That is MIGHT, allow you to upgrade to LR 6 for free.
That is an Un-Known as LR 6 has not come out and Adobe has not stated whether or not that older policy will be extended to new buyers of LR 5.
You certainly would not get the Creative Cloud version as really that version is only available in the bundled Photography package of Photoshop + Lightroom. Lightroom itself, by itself, is not offered on Creative Cloud.