I think aromatic tobaccos might get that "smells great" thing... here are a couple

1... MacBaren's Vanilla Creme - I remember just walking on the sidewalk after dark having this and a guy leaving leaving a truck he parked by the sside of the road and walking up to a house said "is that a pipe? That's smells awesome" .

2... Captain Black ... very mainstream and some may put their noses up but it smells good. Some things similar might be the Mac Baren '7 Seas' types

----------------

I usually get non-aromatic tobaccos. I tend to like things with latakia tobacco as part of the mix.

1... King Charles (by JF Germain & Sons , Jersey island)
2... Artisan's Blend (by Ashton)
3... Syrian Latakia Blend (by McLintock)
4... Squadron Leader (by Samuel Gawith)
5... right now have a tin of Peterson's 'Hyde Park' which has rum and maple sugars added (so I suppose it's a bit of an aromatic)