Ride is a very subjective topic and depends a lot on the final tire choice after level. Mine at 2.8 rides very different than stock, wont say better or worse, but different... think firmer. Some scenario's the added firmness is great, other scenarios it feels stiff... but like I said tires play a big role in that also.
If you stick with a stock size the ride will be better due to the lighter rated tires. You jump up to 34"+ tires and they're gonna be 10ply tires that are stiffer by nature and ride a little rougher. Running 33's with 24" rims will ride worse than 33's with 17" rims due to sidewall differences, etc....
If you do enough reading on here, you'll be hard pressed to find many if any that regret leveling their trucks. The best I can say is my truck now rides like a truck, which I'm totally fine with since it is indeed a truck. If you look through the "alright guys bilsteins post your pics" thread you'll see numerous leveled trucks on stock wheels & tires.