Well on the ftp is the RH 8 Personal Ed. The $40 one. And unless you need fancy server shit and printed manuals, the Pro is not necessary really.
As for if you should stick with RH or not -- up to you. If you prefer GNOME and GTK applications, RedHat has the best GNOME 2.0 implementation yet. Their tweaks really help out. AS for KDE, RedHat's tweaks are minor and really haven't separated it far enough for me to say that RH has 'improved' KDE. But that could change (unlikely however).
Mandrake and SuSE are great if you want wizards to do shit for ya. Slackware is perfect for those who know what the hell they are doing and want something that is stable and just plian works. I have never used debian, so my comments there would be pure speculation. My reccomendation is go with RH 8 or if you hold off, RH 8.1 if you are not %100 comfortable doing all modifications via the CLI. Otherwise definitely Slack 9 when it is released. Slack expects you to have a brain, whereas RedHat and its kin tend to baby just a little (or in MDK 9, alot)
I have (as you may have noticed with my latest few weeks of posts) been toying with SuSE 8.1 and Mandrake 9.0 and have for the most part been pleased, but still feel inclined to use RH 8.
No need to mention that I am the resident GNOME and RedHat whore ...