After some fiddling around, I finally managed to set up my PS3 gamepad with tilt control for looking around. So in order to look in any direction, you just turn the controller! 
In case somebody else wants to try this, here are the steps:
1) Install drivers
Download and install Motioninjoy drivers (0.7.1001) here:
http://www.motioninjoy.com/download
Download and install the Dualshock configuration tool from Better DS3:
http://betterds3.ciebiera.net/
Better DS3 is vastly better than the somewhat dodgy configuration tool included with the Motioninjoy drivers. Run Better DS3 and plug in your PS3 gamepad in a USB port. It should be recognized.
2) Configure the gamepad
Make a New profile in Better DS3 using DirectInput
Use the following settings
Save the profile. Check that it all works from Better DS 3 by selecting "Control Panel" -> "Properties". Click a few buttons, move the sticks around, etc.
3) Configure Elite
Download my custom settings file (Right click -> Save Link as...):
https://dl.dropboxusercontent.com/u/10043989/Elitebinds/Custom_PS3tilt.binds
Put the file here (or wherever you have bindings):
%AppData%\..\Local\Frontier Developments\Elite Dangerous\Options\Bindings
If you want to set this up from scratch yourself, looking up and down is on the JOY V-AXIS and left-right is on JOY RZ-AXIS. I recommend setting a small deadzone on both axes, as it can get a bit twitchy otherwise. Also remember to turn off mouselook! I initially had mouselook on, and the inputs were fighting each other causing mayhem.
4) Check that it all works
Make sure that Better DS3 is running and using the right profile before starting the game.
I've mostly set this up to mimic the Xbox360 controller. A few changes: Pressing L1 and R1 together sets speed to 0. The PS button is set to target next, and holding the start button turns roll into yaw. Pressing down on left stick toggles flight assist. Change to suit your needs.
Edit:
Slight tweak. Since the shoulder buttons, L2 and R2, are used for firing weapons, they need twitch timings. I recommend lowering their "analog to digital threshold" to from 25% to 5%. I can't be bothered to update the image.
In case somebody else wants to try this, here are the steps:
1) Install drivers
Download and install Motioninjoy drivers (0.7.1001) here:
http://www.motioninjoy.com/download
Download and install the Dualshock configuration tool from Better DS3:
http://betterds3.ciebiera.net/
Better DS3 is vastly better than the somewhat dodgy configuration tool included with the Motioninjoy drivers. Run Better DS3 and plug in your PS3 gamepad in a USB port. It should be recognized.
2) Configure the gamepad
Make a New profile in Better DS3 using DirectInput
Use the following settings

3) Configure Elite
Download my custom settings file (Right click -> Save Link as...):
https://dl.dropboxusercontent.com/u/10043989/Elitebinds/Custom_PS3tilt.binds
Put the file here (or wherever you have bindings):
%AppData%\..\Local\Frontier Developments\Elite Dangerous\Options\Bindings
If you want to set this up from scratch yourself, looking up and down is on the JOY V-AXIS and left-right is on JOY RZ-AXIS. I recommend setting a small deadzone on both axes, as it can get a bit twitchy otherwise. Also remember to turn off mouselook! I initially had mouselook on, and the inputs were fighting each other causing mayhem.
4) Check that it all works
Make sure that Better DS3 is running and using the right profile before starting the game.
I've mostly set this up to mimic the Xbox360 controller. A few changes: Pressing L1 and R1 together sets speed to 0. The PS button is set to target next, and holding the start button turns roll into yaw. Pressing down on left stick toggles flight assist. Change to suit your needs.
Edit:
Slight tweak. Since the shoulder buttons, L2 and R2, are used for firing weapons, they need twitch timings. I recommend lowering their "analog to digital threshold" to from 25% to 5%. I can't be bothered to update the image.
Last edited: