Recreational Pilot licenses haven’t been successful in the US, in fact I understand there are only a few hundred of them around. Mainly it’s been used as a way to carry passengers legally earlier than the normal private pilot license allows, and those who get it normally keep going and get their private licenses anyway. Sport Pilot is easier to get and the restrictions on the type of flying you can do don’t really limit all that many pilots - compared to a Private Pilot, it means flying Light Sport Aircraft only (larger than an ultralight, smaller than most private aircraft), daytime only, VFR only, and a valid driver’s license. Medical is basically on the honor system. AOPA is a good place to start researching it.
Sport Pilot instructors are easy to find, since anyone with a Certified Flight Instructor license is already certified for it. The problem is finding a flight school that both has an LSA and has insurance for using it commercially - that last part has been the killer so far. The insurance companies have been reluctant to get into unknown territory.
To your OP, yes, if you want to do it, do it. It doesn’t have to be that expensive or that time-consuming, but you do have to budget for it. The total cost in money and time depends on how frequently you can fly - if you can devote full time to it, you can actually get a private license in a couple of weeks. The longer you go between flights, the rustier you’ll get and the more catch-up you’ll have to do, so it will take more hours. There’s a lot of ground study required, but you can do that with books and DVD’s as effectively as in a formal ground school, and at less cost.
Look for a grand total of $6-10K and 6-12 months if you have other things to do in your life - but that’s less than you’d pay for a decent used car, and your license is good forever. Cost per year is about what a serious golf habit costs. After that, cost is on a per-hour basis if you, like most people, will be renting aircraft. Figure on $100/hr typically including fuel; I pay $78 for an IFR Skyhawk (and it would be $60 for a 150 if I could fit into one), but that’s unusual; most other FBO’s would charge $105 for the same Skyhawk.
Just getting over that first hump, getting started, is the hardest part. If you have a flying friend, you might casually mention you’re thinking of doing it, and I guarantee you’ll get all the help you need. If an airport near you is having an open house, or if you see a training operation there, if you just drop in and mention you’re considering it, then they’ll take care of you from there. There’s a real sense of community and mutual helpfulness among pilots, part of making it fun even when you’re not flying, and newcomers are always welcome.