I like all quilts....regular quilting, heavy quilting, tied. The quilt top design is usually what I look at first. But I have "a thing" with sagging quilt areas that look like they need more quilting. (Just my thing!) Several wool batting quilts I've done with heavier quilting (not super dense but heavier quilting) are quite soft. So it's probably an assumption to say heavy quilting is going to stiffen a quilt. Also, on the heavier quilting I used silk or finer thread. A 50 weight cotton thread is starting to look too thick to me, especially when you have to back-track a few times.
Personally I would like to try out denser quilting, but it takes a lot of time that doesn't usually work for me!