I've driven some newer F-Series BMWs, 118i, 320i (normal & MSport) and 528i MSport, all 4cylinders. I guess if you want any sort of excitement you will have to look at the diesel ones and the x35i models as the 4 cylinder petrol models just lack that wow factor. Yes they are faster and more fuel efficient but they just lack soul and are too sanitised and clinical. The one which really disappointed me was the 528i, as I have fond memories of the E39 generation of 5series and drove most of the range, basically I learnt how to drive on the E39 5series before being able to buy my own BMW. The 528i just (to me) did not feel as solid and as smooth as the older generation which I experienced. Yes there were lots of toys in the cabin but on pure driving side, I found it rather boring. I would expect this to also filter through onto the current F series 328i/330i and you really can not compare them to E36 328i E46 330i E90 330i, as the older generations are different beasts altogether and deliver a different type of driving experience.
For me, they feel like rear wheel drive Audis now, and I have driven a lot of Audi (quiet cabin, linear power delivery and smooth almost seamless shift transmission). The OP refers to E46 generation which and I can understand why the disappointment with the newer F-Series BMWs. Back then you were not paying half a bar for an entry level BMW sedan. My personal experience with E46 was a 323ci and 320i MSport (2.2l 6ylinder), I really enjoyed the way that E46 320i drove, it only had a modest 125kw power output, it performed admirably, if consider the big brother 330i was 160kw, it was velvet smooth, punchy, sounded fantastic and devoured corners. I think I paid around R140K for it in 2005/6, & I still consider it very good bang for buck buy and really was fun to drive, something which the drive in F30 320i did not deliver.
I guess with each generation of 3 series the growth in size has blunted the sportiness of the model. Also another thing to consider is how much electronic wizardry there is in a newer generation vehicle to keep it on the road. Back in the day, I recall my first ride in an E36 M3 2 door, will never forget it, road slightly damp, on full throttle take off the rear end is dancing all over the place, no traction control at all, and it takes real skill to keep that on the road. I think the Z3 MCoupe also did not have traction control. A vehicle may be newer and have newer technology and even have better specifications on paper but it does not necessarily mean it translates into a better on road driving experience.